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-13418: null or invalid parameter(s) for set functions

1 Answers  


TNS-04208: Trace Assistant Internal ERROR: Fatal

1 Answers  


ORA-09789: sllfsk: unable to read file.

1 Answers  


ORA-19593: datafile number string already included as string

1 Answers  


DRG-50913: first document requested string is not a positive number

1 Answers  


NNO-00272: line string; invalid DIT/DN

1 Answers  


TNS-01400: Instance "string" has number handlers.

1 Answers  


ORA-12519: TNS:no appropriate service handler found

1 Answers   Oracle,


ORA-09740: slsget: cannot get virtual memory region statistics.

1 Answers  


RMAN-05012: trying to start the Oracle instance without parameter files ...

1 Answers  


KUP-04104: zoned decimal field has bad values for string

1 Answers  


ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 Answers  


Categories