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 |
PCC-02428: Buffer type is incompatible with LOB type
PLS-00391: undefined column 'string' in UPDATE statement
NCR-03021: NCRO: Reset the in-band line
ORA-02778: Name given for the log directory is invalid
ORA-22631: attribute [string] is is not well-formed or does not match the type
TNS-00213: Available Connections : number
ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.
ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-12351: cannot create view using a remote object which has a remote object reference
PCC-00107: The CONNECT statement is Oracle implementation dependent
PCC-00091: TYPE statement requires format specification for this Oracle datatype
QSM-00511: invalid fact-tables specified in fact-filter