John Saylor wrote:
> I need to call a stored procedure, and I can't find the documentation
> and I'm not sure I remember the syntax, so I'm writing this note in the
> hope that someone will help me.
>
> I think it's something like this:
> $s = 'STORED PROCEDURE ( var1, var2 )";
> $dbh->do ( $s );
>
> With all the error checking stuff left out for brevity.
>
> Am I right?
I'm sorry I was away on vacation, starting the day you asked this
question...
No, as you will have found out by now. The magic word is 'EXECUTE' in
place of 'STORED'.
If the procedure returns values, then you need to treat it as if it was a
SELECT statement (in Informix and hence DBD::Informix -- the rules may be
different for other DBMS).
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
