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 |
PLS-00751: cannot find PACKAGE SYS_STUB_FOR_PURITY_ANALYSIS
NID-00139: Mismatched dbname for datafile string, expected string, found string
ORA-27073: Trying to close a file which has async I/Os pending to be dequeued
PLS-00493: invalid reference to a server-side object or function in a local context
PCC-02107: You may not specify PARSE = FULL when CODE = CPP
ORA-19508: failed to delete file "string"
ORA-14294: Number of partitions does not match number of subpartitions
ORA-09260: sigpidu: error obtaining process id
ORA-26672: timeout occurred while stopping STREAMS process string
NNL-00568: delegate_domain <domain_name> <NS_name> <NS_Addr> : Delegate the given domain to the given nameserver
ORA-12719: operation requires database is in RESTRICTED mode
ORA-26501: RepAPI operation failure