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-07282: sksaprd: string overflow.
ORA-12632: Role fetch failed
PLS-00388: undefined column 'string' in subquery
ORA-23474: definition of "string"."string" has changed since generation of replication support
ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH
ORA-22337: the type of accessed object has been evolved
QSM-01041: materialized view, string, does not match with a measure in the query
ORA-08317: sllfsk: Error seeking in file.
DRG-11107: invalid path specification: string
ORA-25958: join index where clause predicate may only contain column references
ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type
NID-00143: Mismatched controlfile string