Re: Stored Procedures...

Posted in 1997

miroslav.lorenc@ssa.co.uk — 28 Jan 1997 11:18:13 -0500 — source: Informix-list mailing list archive (1991-1998)

MIME :bicudo @ elogica.com.br 25/01/97 18:27 To: -:informix-list @ rmy.emory.edu@INTERNET, Miroslav Lorenc cc: =20 Subject: Stored Procedures... :Hi All, : : Anyone knows how can I issue an "Select * from table FOR UPDATE" withi= n :a Store Procedure ?? Every time I try this one, I get an error message...=20= :( : :TIA, : :Romulo Albuquerque :bicudo@elogica.com.br If you give a name to cursor inside stored procedure (FOREACH cursor_name F= OR=20 SELECT ... ), the cursor is declared as cursor for update. Cursor without=20 explicite name (FOREACH SELECT ...) is declared just as common cursor. FOR UPDATE clause is not available in SPL (and is not needed). Regards, Miroslav Lorenc email Miroslav.Lorenc@ssa.co.uk