Subject Parameters for TIBOQuery with stored procedure
Author andygarneruk
Could someone point me in the right direction please?

I have set the design time properties for a TIBOQuery to return
records from a stored procedure (FOR SELECT ... DO ... SUSPEND), but
I get ISC error "parameter mismatch for stored procedure <name>" when
setting the query active.

So I tried with example procedure MAIL_LABEL in employee.fdb (which
takes one input parameter) but get the same error. I also tried with
TIB_Query, but this would not prepare at design time, so I could not
set the Params.

What am I doing wrong please?
D7, IBO 4.2.Ie

object IB_Connection1: TIB_Connection
PasswordStorage = psNotSecure
SQLDialect = 3
Params.Strings = (
'PATH=C:\Program Files\Firebird\Firebird_1_5
'USER NAME=sysdba'
SavedPassword = '.JuMbLe.01.432B0639073E0E4B49'

object IBOQuery1: TIBOQuery
Params = <
DataType = ftInteger
Name = 'cust_no'
ParamType = ptInput
Value = 1001
DatabaseName =
'abs-s01:C:\Program Files\Firebird\Firebird_1_5
IB_Connection = IB_Connection1
RecordCountAccurate = True
SQL.Strings = ('select * from mail_label')
FieldOptions = []