Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

PCC-02445

USING clause valid only on a PREPAREd dynamic statement

Cause

The USING clause was used with an OPEN cursor statement where the cursor declaration was not for a PREPAREd statement. The correct sequence of statements should be as follows EXEC SQL PREPARE s FROM :stmt; EXEC SQL DECLARE c CURSOR FOR s; EXEC SQL OPEN c USING ...;


Action

Use the PREPARE statement for the SQL statement and use that in the DECLARE CURSOR statement.