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-30653: reject limit reached
ORA-01616: instance string (thread string) is open - cannot disable
ORA-16582: Could not edit instance specific property.
ORA-22340: cannot string type "string"."string". Dependent tables must be upgraded to latest version
NID-00480: Database is intact - database is ready to be open or shut down.
ORA-14309: Total count of list values exceeds maximum allowed
RMAN-06026: some targets not found - aborting restore
TNS-02403: Bad alias string or alias not present in tnsnames.ora
QSM-02088: mv omits at least one grouping key from the select list
ORA-00448: normal completion of background process
ORA-31503: invalid date supplied for begin_date or end_date
ORA-06423: NETCMN: Error in receiving data