1 Reply Latest reply: Jun 21, 2011 12:20 PM by Steve.Clamage-Oracle RSS

    PRO C - EXEC PREPARE - Cursors


      I am trying to modify a PRO C program but have some questions. Can anyone tell me what the line EXEC SQL PREPARE statement does? And the EXEC SQL DECLARE does? Also, I am trying to determine how each record gets read in a PRO C program. I don't see any loops around the cursor like you would see any in a PL/SQL program. Any pointers would be helpful.

      Thanks in Advance, Julie

      tmstrcpy8(select_statement_c, tmtochar8(select_statement));
      EXEC SQL PREPARE sql_stmt FROM :select_statement_c;

      EXEC SQL DECLARE cursor_100 CURSOR FOR sql_stmt;