Subject | Re: [firebird-support] Re: message length error (encountered 0, expected 8) |
---|---|
Author | Ivan Prenosil |
Post date | 2004-06-28T21:50:30Z |
> Ah, so its me!! (that's a relief). So if I am using the wrongisc_dsql_execute_immediate()
> function, what is the correct function to use for calling stored
> procedures? Should I do a prepare/execute or something else?
>
> I can certainly add the XSQLDA stuff not that I'm aware its
> required. I thought that was optional.
>From IB documentation:
prepares the DSQL statement specified in statement, executes it once, and discards it.
The statement must not be one that returns data (i.e., it must not be a SELECT or EXECUTE PROCEDURE statement).
If statement requires input parameter values (i.e., if it contains parameter markers), these values must be supplied in
the input XSQLDA, xsqlda.
isc_dsql_exec_immed2()
prepares the DSQL statement specified in statement, executes it once, and discards it.
The statement can return a single set of values (i.e, it can be an EXECUTE PROCEDURE or singleton SELECT)
in the output XSQLDA.
Ivan