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 |
LPX-00306: inputed string ended with no corresponding closing '}'
ORA-24153: rule set string.string already exists
ORA-16139: media recovery required
NNL-00898: Responses sent: number
TNS-12544: TNS:contexts have different wait/test functions
PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal
ORA-12569: TNS:packet checksum failure
DRG-10304: unexpected error sending command(s) to Oracle Text server
ORA-19506: failed to create sequential file, name="string", parms="string"
ORA-15060: template "string" does not exist
LPX-00256: invalid element declaration
ORA-39050: parameter string is incompatible with parameter string