Re: Calling STORED PROCEDURE from INFORMIX-4GL

In article: <4l6pnr$t2f@hpscit.sc.hp.com> kok-bin_lee@hp.com (Kok-Bin) writes: > Could anyone pls provide me some sample code demonstrating how to call stored > procedure in INFORMIX-4GL. I believe calling stored procedure in 4GL needs > other statements on top of EXECUTE PROCEDURE. > > Thanks alot. > -- If it doesnt return anything: prepare p_st1 from "execute procedure does_something()" execute p_st1 If it does: prepare p_st2 from "execute procedure does_something()" declare curs_1 cursor for p_st2 foreach curs_1 into var1,var2.... ..do something end foreach +------------------------------------------------------------- -------+ > | LEE Kok-Bin | > | kok-bin_lee@hp.com | > | Standard Disclaimer | > +------------------------------------------------------------- -------+ > > -- Mike Aubury _\\?/_ |O O| +----------oOOO-\\_/-OOOo---------+---------------------------- -+ | Heisenberg may have been here | mike@aubury.demon.co.uk | +--------------------------------+---------------------------- -+