PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field
Cause: Illegal syntax was used to call a parameter-less function that returns a record or a PL/SQL table of records. When calling a function that takes parameters and returns a record, you use the following syntax to reference fields in the record: function_name(parameters).field_name However, you cannot use the syntax above to call a parameter-less function because PL/SQL does not allow empty parameter lists. That is, the following syntax is illegal: function_name().field_name -- illegal; empty parameter list You cannot just drop the empty parameter list because the following syntax is also illegal: function_name.field_name -- illegal; no parameter list.
Action: Declare a local record or PL/SQL table of records to which you can assign the function result, then reference its fields directly.
PLS-00510
Custom Search


More Oracle errors
DRG-52202invalid class name: string
ORA-06712TLI Driver: error on accept
ORA-25000invalid use of bind variable in trigger WHEN clause
ORA-22826cannot construct an instance of a non instantiable type
ORA-01156recovery in progress may need access to files
ORA-38136invalid attribute name string specified
ORA-55520Log record in compatibility lower than 11.0
CRS-00413Could not initialize the Cluster Synchronization Services context
ORA-27074unable to determine limit for open files
ORA-24379invalid user callback type
RMAN-06158validation succeeded for archived log
ORA-32130invalid offset/index refrenced in Bytes
ORA-23475key column string must be sent and compared
OCI-30157An invalid argument was given to operating system call
ORA-07606szprv: $CHKPRO failure
ORA-56601DRCP: Illegal connection class
ORA-31671Worker process string had an unhandled exception.
ORA-16809multiple warnings detected for the database
LSX-00133attribute "use" has invalid value "~S"
KUP-04066error initializing access to external table source




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-00509Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field