PCC-02445: USING clause valid only on a PREPAREd dynamic statement

PCC-02445: USING clause valid only on a PREPAREd dynamic
statement

Question Posted / guest

1 Answers
2099 Views
I also Faced
E-Mail Answers

PCC-02445: USING clause valid only on a PREPAREd dynamic statement..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer