PCC-02445: USING clause valid only on a PREPAREd dynamic
statement
- 1 Answers
- 2917 Views
- I also Faced
- E-Mail Answers
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 |
SQL-02115: Code interpretation problem -- check COMMON_NAME usage
ORA-32058: operation restricted to SYSDBA users
ORA-14194: only one subpartition may be rebuilt
NNL-00009: encryption of server password failed
ORA-09747: pw_detachPorts: server call pws_detach failed.
ORA-39003: unable to get count of total workers alive
TNS-00060: INTCTL: Bad command: only the STATUS command can be used on remote Interchanges
TNS-01409: Instance "string"
ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
ORA-13615: The task or object string is greater than the maximum allowable length of 30 characters.
ORA-29287: invalid maximum line size
ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM
Oracle Errors 
