Re: Calling STORED PROCEDURE from INFORMIX-4GL

> > >If the procedure returns values, then you need to declare a cursor, open it, > >and do a fetch: > > prepare proc_stmt from "execute procedure <procname> (?,?,etc)" > > declare proc_curs cursor for proc_stmt > > open proc_curs using arg1, arg2, etc > > fetch proc_curs into var1, var2, etc > > Ya don't NEED to prepare it. EXECUTE PROCEUDRE... works fine. Provided that the version of 4gl in question is knowledgable about these things. In the archaic 4.10 you still need to prepare it. I don't know at what version it became aware (I am assuming that you speak the truth). cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________