Re: Stored Procedure

Posted in 1994

David I. Berg — 23 Dec 94 16:55:58 GMT — source: Informix-list mailing list archive (1991-1998)

shanke11@merlion.singnet.com.sg (Kalyanaraman.L) writes: >Is there any way to use Stored procedure and triggers under informix-4GL. Triggers operate upon an event which occurs to a table. They are not at all specific to any client tool. Stored Procedures are executed through 4GL by preparing and executing a 4GL statement. If the procedure returns any values to the 4GL program, then a cursor must be used to fetch the returned values. For example: PREPARE proc_stmt FROM "EXECUTE PROCEDURE procname(?,?,...,?)" DECLARE proc_curs CURSOR FOR proc_stmt OPEN proc_curs USING parameter_list FETCH proc_curs INTO program_variable_list CLOSE proc_curs ___ ___ Senior Consultant / ) __ . __/ /_ ) _ _ __ Informix Software Inc. (303) 850-0210 _/__/ (_(_ (/ / (_(_ _/__) (-' ~/ '(_- 5299 DTC Blvd #740 Englewood CO 80111