PCB-00557: USING clause can only be used on a PREPAREd
dynamic statement
Answer / guest
Cause: A severe semantics error occurred because the USING
clause was used with the OPEN cursor statement and the
cursor declaration is not for a PREPAREd statement. The
correct sequence of statements should be like: EXEC SQL
prepare sv from :sel_stmt END-EXEC. EXEC SQL declare csv
cursor for sv END-EXEC. EXEC SQL open csv USING :hv1, :hv2
END-EXEC.
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 |
ORA-28046: Password change for SYS disallowed
ORA-09919: Unable to set label of dedicated server
ORA-29856: error occurred in the execution of ODCIINDEXDROP routine
ORA-02334: cannot infer type for column
ORA-00310: archived log contains sequence string; sequence string required
NNL-00289: Scheduled cache flush to occur in string
TNS-12602: TNS: Connection Pooling limit reached
TNS-12609: TNS: Receive timeout occurred
RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability
ORA-39067: Unable to close the log file.
ORA-16567: Data Guard broker internal parser error at "string"
ORA-22819: scope of input value does not correspond to the scope of the target