PLS-00624: USING clause must be used with either aggregate or pipelined functions
Cause: USING clause cannot be used with functions that are not declared with AGGREGATE or PIPELINED properties.
Action: Define function body in PL/SQL or some other language (using external callout call specification).
PLS-00625
Custom Search


More Oracle errors
ORA-16011Archivelog Remote File Server process in Error state
ORA-56713Insufficient Resource Manager privileges
ORA-24420OCISessionRelease must be used to release this session.
ORA-53430The DICOM object contains unsupported values string.
PCC-02335body of cursor must name statement identifier
DIA-48411The trace files exceeds the maximum number [string]
PLS-00731ALTER TYPE is supported only on schema-level types
PROT-00415Make sure you have file creation privileges in the above directory before running this tool.
ORA-19179FOTY0011: Type error. Context item is not a node
ORA-13061topology with the name string does not exist
NNL-00506reset_stats [<server_list>] : reset Names server statistics
ORA-28239no key provided
PLS-00659constructor method must return SELF AS RESULT
ORA-24370illegal piecewise operation attempted
ORA-39211unable to retrieve dumpfile information as specified
ORA-36166(XSMXAGGR08) workspace object is not a VARIABLE.
NNL-00523Renames an existing name
LPX-00751arguments "~s" are exclusive
ORA-24026operation failed, queue string.string has errors
ORA-31214DBMS_LDAP: PL/SQL - Invalid LDAP mod type.




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
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
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-00624USING clause must be used with either aggregate or pipelined functions