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-12713: Character data loss in NCHAR/CHAR conversion
ORA-24351: invalid date passed into OCI call
ORA-37032: (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
ORA-01032: no such userid
LPX-00653: Output attribute '~S' doesn't have a parent element.
O2F-00312: Illegal or missing type version string
ORA-16613: initialization in progress for site
ORA-23340: incorrect resolution method string
ORA-12854: Parallel query is not supported on temporary LOBs
ORA-07614: $CHANGE_CLASS failed in retrieving the user's process label
RMAN-08599: channel string: throttle time: string
DRG-50930: parser memory failure on line string on column string