PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT
Cause: An OPEN cursor statement or cursor FOR loop can only invoke a SELECT statement, not an UPDATE, INSERT or DELETE.
Action: Use only SELECT statements in OPEN or cursor FOR loops
PLS-00171
Custom Search


More Oracle errors
RMAN-12007cannot allocate more than number channels
ORA-15008cannot drop system template
ORA-24394invalid mode for destroying connection pool
ORA-32775cannot change size attributes of read only tablespace string
ORA-15106missing or invalid operating system disk locator string
NZE-29013SSL MAC verification failure
TNS-01169The listener has not recognized the password
IMG-00835merged area queue size exceeds expected size
ORA-02297cannot disable constraint (string.string) - dependencies exist
TNS-12151TNS:received bad packet type from network layer
PCC-01017The SQLCA and a SQLCODE variable cannot both be used
OCI-31087insufficient privileges to delete schema "string"
ORA-37138(XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
ORA-08459invalid format parameter length
ORA-14273lower-bound partition must be specified first
ORA-37601(XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
SQL-02113Unable to open message file
LPX-00759failed to initialize TCP/IP
SQL-02156Invalid type for Indicator or Returned Length
ORA-12085materialized view log on "string"."string" already has object id




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
PLS-00170the SQL statement in an OPEN statement or FOR loop must be a SELECT