PROC Problem : Select for update

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 - 11:52:29 CDT