PROC Problem : Select for update
From: Oracle 9Ri2 AS 2.1 IA 64 <rbenzarti_at_hotmail.com>
Date: 20 Aug 2004 09:52:29 -0700
Message-ID: <7fa25ffe.0408200852.41c1de37_at_posting.google.com>
Hello,
I am working with Oracle 9Ri2 version on Linux AS 2.1 for IA64.
Date: 20 Aug 2004 09:52:29 -0700
Message-ID: <7fa25ffe.0408200852.41c1de37_at_posting.google.com>
Hello,
I am working with Oracle 9Ri2 version on Linux AS 2.1 for IA64.
I have a problem when i try to lanch the following program :
EXEC SQL PREPARE MyStmt FROM
SELECT CHAMP1 FROM TAB1 WHERE CHAMP2="4" AND CHAMP3 = "C" FOR UPDATE; EXEC SQL DECLARE MyCursor CURSOR FOR MyStmt;
EXEC SQL OPEN MyCursor;
EXEC SQL DESCRIBE MyStmt into q_APP;
EXEC SQL FETCH MyCursor into :Var1;
EXEC SQL CLOSE MyCursor;
When I don't use the PREPARE Statement i don't have problem. But when i add the PREPARE statement program crached when it try to Open Cursor ( EXEC SQL OPEN MyCursor)
Thank you for your help. Received on Fri Aug 20 2004 - 18:52:29 CEST