PLS-00493: invalid reference to a server-side object or
function in a local context



PLS-00493: invalid reference to a server-side object or function in a local context..

Answer / guest

Cause: A reference to a server-side object (e.g. a table
column) or function (a group function such as SUM, AVG, MIN,
MAX, ... ) was found in a context where only PL/SQL objects
may be present (such as within the parameter list of a local
function or as the index of a (local) PL/SQL table.)

Action: Rewrite the offending statement; or (if a local
function call is the problem context), make the function
non-local (either packaged or top- level.)

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12448: policy string not applied to schema string

1 Answers  


ORA-02250: missing or invalid constraint name

1 Answers  


QSM-01046: complex join back on correlated columns not allowed (string)

1 Answers  


RMAN-08059: media recovery failed

1 Answers  


QSM-00510: statistics missing on materialized views

1 Answers  


TNS-00505: Operation timed out

1 Answers  


DRG-50918: mismatched close escape character

1 Answers  


ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool

1 Answers  


IMG-00810: boundary queue initialization failed

1 Answers  


PLS-00151: Expression or Variable is an illegal type to PLS/QL: string

1 Answers  


ORA-25534: _MEAN_TIME_TO_CLUSTER_AVAILABILITY is specified

1 Answers  


ORA-02142: missing or invalid ALTER TABLESPACE option

1 Answers  


Categories