PLS-00428: an INTO clause is expected in this SELECT statement
Cause: The INTO clause of a SELECT INTO statement was omitted. For example, the code might look like SELECT deptno, dname, loc FROM dept WHERE ... instead of SELECT deptno, dname, loc INTO dept_rec FROM dept WHERE ... In PL/SQL, only a subquery is written without an INTO clause.
Action: Add the required INTO clause.
PLS-00429
Custom Search


More Oracle errors
ORA-12618TNS:versions are incompatible
ORA-01158database string already mounted
DRG-11869Premature End Of File Detected
LSX-00200element "~S" not empty
ORA-55557Trigger 4144 corruption
NNO-00627cancelling auto-refresh of name "string", type "string"
PCB-00576PLS-number: string
ORA-55510Mining could not start
PGA-21042error creating file object for log file
ORA-25270sender info does not match with the actual sender of the message
ORA-10576Give up restoring recovered datafiles to consistent state: some error occurred
TNS-00532No previous async operation to wait on
ORA-01122database file string failed verification check
ORA-19164XQST0085 - It is a static error if the namespace URI in a namespace declaration attribute is a zero-length string, and the implementation does not support [XML Names 1.1].
ORA-32301object-relational materialized views must be primary key based
ORA-22816unsupported feature with RETURNING clause
DRG-11860Connection Establishment Interrupted
TNS-04002The command completed successfully.
RMAN-06613Connect identifier for DB_UNIQUE_NAME string not configured
TNS-12678Authentication disabled but required




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-00428an INTO clause is expected in this SELECT statement