Re: PROC Problem : Select for update

rbenzarti_at_hotmail.com (Oracle 9Ri2 AS 2.1 IA 64) wrote in message news:<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.

  You don't need a prepare as u are not using any bind variables.    Also i wonder why u are using describe . its not needed.

   Best Regards
   J Received on Thu Aug 26 2004 - 14:07:32 CEST