PLS-00372: In a procedure, RETURN statement cannot contain an expression
Cause: In a procedure, a RETURN statement contains an expression, which is not allowed. In functions, a RETURN statement must contain an expression because its value is assigned to the function identifier. However, in procedures, a RETURN statement simply lets you exit before the normal end of the procedure is reached.
Action: Remove the expression from the RETURN statement, or redefine the procedure as a function.
PLS-00376
Custom Search


More Oracle errors
IMG-00701unable to set the properties of an empty image
ORA-09946File name too long for buffer
PGU-00110illegal SET option
ORA-01525error in renaming data files
ORA-28003password verification for the specified password failed
PCB-00556Unrecoverable error. Fix previous errors and re-precompile
ORA-38789File name is too long.
ORA-22880invalid REF
IMG-00577invalid quantize argument
ORA-01156recovery in progress may need access to files
RMAN-06550clone database not mounted and db_name not set in init.ora
ORA-17506I/O Error Simulation
ORA-53035The rows for the mapping document (string) do not exist.
ORA-12557TNS:protocol adapter not loadable
ORA-01247database recovery through TSPITR of tablespace string
IMG-00704unable to read image data
NNO-00071cannot construct cache checkpoint file name
ORA-19506failed to create sequential file, name="string", parms="string"
LPX-00708SOAP failed to make HTTP connection
DRG-11604URL store: access to string is denied




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-00372In a procedure, RETURN statement cannot contain an expression