PLS-00360: cursor declaration without body needs return type
Cause: A cursor declaration lacks either a body (SELECT statement) or a return type. If you want to separate a cursor specification from its body, a return type must be supplied, as in CURSOR c1 RETURN emp%ROWTYPE;
Action: Add a SELECT statement or return type to the cursor declaration.
PLS-00366
Custom Search


More Oracle errors
ORA-29919failed in the execution of the ODCIINDEXUPDPARTMETADATA routine
ORA-12511TNS:service handler found but it is not accepting connections
ORA-00352all logs for thread string need to be archived - cannot enable
RMAN-06514archived logs required to recover from this copy will not be kept
ORA-26717SCN limit reached
DRG-10301timed out waiting for responses from servers
ORA-07267spwat: invalid process number.
RMAN-05510Duplicate finished
NZE-28810Cannot create key descriptor.
LPX-00052LEH initialization failed
PGU-39119EP string, c#string, d#string, f#string, string
QSM-02189materialized view definition changes
ORA-39204No subsetting of tablespaces is allowed for transportable import.
TNS-00090* Interchange - will ask the Interchange
RMAN-06438error executing package DBMS_RCVMAN in string database
ORA-36200(XSAGGR34) AGGREGATE operator string requires a WEIGHTBY clause, but ARGS variable workspace object did not specify one.
ORA-12739Express Instant Client: unsupported client character set string
ORA-02038define is not allowed for array type
ORA-02171invalid value for MAXLOGHISTORY
RMAN-06785This operation might take some time.




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-00360cursor declaration without body needs return type