Thank you, that was the problem. Don't know how I missed that. Sometimes the simplest thing will trip you up.
Chris ----- Original Message ----- From: "Anil Menon" <[EMAIL PROTECTED]> To: "Christopher Mihaly" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 25, 2003 2:40 AM Subject: Re: How to call a stored procedure > 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. > > Anil Menon > MIS Team. > > To invent, you need a good imagination and a pile of junk. We have both. > - MIS @ Rhythm & Hues Studios. >