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
SQL*Loader-00523error number writing to file (string)
NNL-00023SET command is missing an argument
ORA-02198ONLINE/OFFLINE option already specified
ORA-09768osnmgetmsg: could not read a message
IMG-00545invalid cut values specified
ORA-22854invalid option for LOB storage index
ORA-24060cannot convert QUEUE_TABLE, string already is compatible with release string
TNS-12583TNS:no reader
ORA-12473The procedure is disabled when Label Security is used with OID.
ORA-01239database must be in ARCHIVELOG mode to use external cache
ORA-12665NLS string open failed
ORA-12824INSTANCES DEFAULT may not be specified here
DRG-50850string
SQL*Loader-00556unable to allocate read buffer
IMG-00612unable to open export destination file
TNS-04082string event string set to string.
ORA-60009adding (string) blocks to LOB segment string.string partition string with MAXSIZE (string)
ORA-15007name is already used by an existing template
TNS-04235Trace Assistant WARNING: Unknown TTC protocol
TNS-02405GMS call failed, check GMS logs.




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