PCB-00557: USING clause can only be used on a PREPAREd dynamic statement
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.
PCB-00558
Custom Search


More Oracle errors
ORA-09760osnpui: cannot send break message
QSM-01024materialized view, string, has unknown compile errors
NNL-00958Name nodes freed: number
RMAN-08181media recovery complete, elapsed time: string
ORA-12447policy role already exists for policy string
PCC-00040Unable to open listing file "string"
DRG-10599column is not indexed
DIA-48104read mismatch on blocks requested and returned, [string], [string]
ORA-09835addCallback: callback port is already in a set.
ORA-29270too many open HTTP requests
ORA-28275Multiple mappings for user nickname to LDAP distinguished name exist.
ORA-32842value for property string cannot be altered
ORA-29303user does not login as SYS
ORA-21708inappropriate operation on a transient object
ORA-28666option not allowed for an index on UROWID column(s)
NNL-00233Auto-refresh failure-retry interval is now string
ORA-23474definition of "string"."string" has changed since generation of replication support
EXP-00064string is an inner nested table and cannot be exported.
KUP-04016unknown SLF status code number
CLST-02103Unable to parse TCP port options specified.




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
PCB-00557USING clause can only be used on a PREPAREd dynamic statement