>
>
> On Wed, 25 Jun 2003, Christopher Mihaly wrote:
>
> ++ Okay, this is probably a basic question, but I can't
> find it. How
> ++ do you call a stored procedure in Informix. The stored
> procedures I
> ++ want to call don't return anything, and take zero to two
> parameters?
> ++ I have tried to do a $db->do("execute STOREPROC($arg)") and that
> ++ gives back a syntax error, tried leaving the execute off and that
> ++ errored. Help would be appreciated
> ++ :-)
> ++ Thanks
> ++ Chris
>
>
> $db->do("execute procedure STOREPROC($arg)") should solve the
> problem. You missed the word "procedure" in the execute command.
That depends upon the database you are using. For Oracle, it would be
$db->do("begin STOREPROC($arg); end;");
Jeff
