*** Cursor - Opening and Closing ***

Dear Friends:

        Can I do the following in a Pro*C program?:

        strcpy (sqlcmd, "insert into ...");

        EXEC SQL DECLARE C1 CURSOR FOR sqlcmd;

        EXEC SQL OPEN C1;         .......

        EXEC SQL CLOSE C1;         I get the following error when I tried something  like this:

Precompiling test.pc
 127 EXEC SQL DECLARE C3 CURSOR FOR sqlcmd;

 127 .......................................^
     PCC-S-0014:  Undeclared SQL Identifier "C3" at 
     line 127 in file test.pc

Please excuse me if this is a FAQ.

Thanks in advance,

-Badri Received on Wed May 11 1994 - 03:42:39 CEST