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



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

More Oracle Errors Interview Questions

PCC-02320: arithmetic expression does not have correct operand types

1 Answers  


ORA-09793: szguns: length of user name is greater than buffer.

1 Answers  


UDI-00052: incorrect Data Pump client for operation: string

1 Answers  


CLSS-03202: out of sync with master: [string] [string] [string] [string]

1 Answers  


ORA-40223: data mining model import failed, job name=string, error=string

2 Answers  






ORA-27157: OS post/wait facility removed

1 Answers  


TNS-12649: Unknown encryption or data integrity algorithm

1 Answers  


ORA-39103: Timeout before worker process string finished initialization. Worker error:

1 Answers  


ORA-00032: invalid session migration password

1 Answers  


NZE-28837: no wallet descriptor

1 Answers  


SQL*Loader-03120: Resumable parameters ignored -- current session not resumable

1 Answers  


ORA-26095: unprocessed stream data exists

0 Answers  


Categories