Re: 4GL Calling Stored Procedures

Posted in 1998

Felix Mathews — Thu, 30 Apr 1998 16:14:01 -0700 — source: Informix-list mailing list archive (1991-1998)

Client Server Technologies wrote: > I am trying to call a stored procedure that returns values from a 4GL > application, and the only way that I have gotten it to work is by opening > a cursor. Is there a simpler way to execute the procedure and return them > into my 4GL variables. <snip> If your stored procedure is returning one set of value(s), then you have a way other than prepare and execute. If you SP is validate_account() returning true or false. Then you can do the following select validate_account(account_number) from systables where tabid = 1 or select validate_account(account_number) into validation_flag from systables where tabid = 1 -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com