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-30746: error occured while trying to drop column "string" in table "string"
PCC-00041: Unable to open output file "string"
PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression
RMAN-05020: cannot specify AUXILIARY DESTIONATION option for normal recovery
ORA-39040: Schema expression "string" must identify exactly one schema.
SQL*Loader-00515: Error getting CPU time
PLS-00663: the NEW keyword is not allowed in this context
NCR-04009: NCRR: Object exists
ORA-32310: object materialized views must select from an object table
ORA-06313: IPA: Shared memory failed to initialise
PLS-00166: bad format for date, time or timestamp literal
ORA-16127: stalled waiting for additional transactions to be applied