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-01938: IDENTIFIED BY must be specified for CREATE USER
NZE-28788: user provided invalid information, or an unknown error
ORA-03282: missing ALLOCATE EXTENT option
ORA-23345: table "string"."string" not registered to collect statistics
DRG-10827: open_con must be performed before count_last
NNL-00950: Cache lookup requests: number
DRG-11212: procedure filter procedure name contains a semicolon
ORA-16061: Log file status has changed
ORA-32840: property name cannot be NULL
ORA-16570: operation requires restart of database "string"
DRG-52100: %(1)s returned internal error code string
NNC-00500: warning: "string" parameter value is illegal, setting to string