Re: how to: run stored proc from 4gl code

Posted in 1998

Art S. Kagel — Thu, 15 Oct 1998 18:03:10 -0400 — source: Informix-list mailing list archive (1991-1998)

Pavel Berzin wrote: > > Hi, all! > Please help. > How to run stored procedure from 4gl code? > > I did so: > 1. stored procedure returns one value > 2. 4gl code is like this > DEFINE ii integer > EXECUTE PROCEDURE aaa() INTO ii> > Doesn't work. > > "You must declare cursor procedure before ... bla-bla-bla" 4GL does not understand the EXECUTE PROCEDURE syntax so you have to PREPARE a statement with the EXECUTE PROCEDURE statement in a string variable. Then declare and execute a cursor. Art S. Kagel