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
EXEC SQL PREPARE sql_stmt FROM :select_statement_c;
EXEC SQL DECLARE cursor_100 CURSOR FOR sql_stmt;
Pro*C is not part of Solaris Studio. (Confusing, I know.)
You will have better luck with Pro*C questions in an Oracle Database forum. Start here: