PLS-00222: no function with name exists

PLS-00222: no function with name 'string' exists in this scope

Cause: An identifier being referenced as a function was not declared or actually represents another object (for example, it might have been declared as a procedure).

Action: Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.

PLS-00222: no function with name 'name' exists in this scope:

It cannot find the 'function' specified. This may be a packaged or standalone function.

If the routine is spelt correctly then the clue to the problem may be the word 'function' in the error message. It is looking for a function as opposed to a procedure. Perhaps it is really a procedure but has been mis-called, i.e. with a return variable.

ORA-00060: deadlock detected while waiting for resource

ORA-00936:missing expression

ORA-02063 remote db error and how to fix it

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-04091: table is mutating trigger

ORA-00604: error occurred at recursive SQL level string

PLS-00222: no function with name exists

ORA-00600: internal error code arguments:

ORA-21000:error number argument to raise_application_error is out of range

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00001: unique constraint

ORA-00017: session requested to set trace event

ORA-00018: maximum number of sessions exceeded

ORA-00019: maximum number of session licenses exceeded

ORA-00020: maximum number of processes exceeded.

ORA-00021: session attached to some other process; cannot switch session

ORA-00022: invalid session ID; access denied

ORA-00023: session references process private memory; cannot detach session

ORA-00024: logins from more than one process not allowed in single-process mode

ORA-00025: failed to allocate string

ORA-00026: missing or invalid session ID

ORA-00027: cannot kill current session

ORA-00028: your session has been killed

ORA-00029: session is not a user session

ORA-00030: User session ID does not exist.

ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00055: maximum number of DML locks exceeded

ORA-00060: deadlock detected while waiting for resource

ORA-00257: archiver error. Connect internal only, until freed.

ORA-00600: internal error code arguments

ORA-00604: error occurred at recursive SQL level string

ORA-00936:missing expression

ORA-00997: illegal use of LONG datatype

ORA-01000:maximum open cursors exceeded

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

ORA-01480: trailing null missing from STR bind value

ORA-01555: snapshot too old: rollback segment number string with name "string" too small

ORA-03237: Initial Extent of specified size cannot be allocated in tablespace

ORA-04030: out of process memory when trying to allocate string bytes

ORA-04031: unable to allocate string bytes of shared memory

ORA-04091: table is mutating trigger

ORA-12154: TNS:could not resolve the connect identifier specified - Oracle Error

ORA-21000:error number argument to raise_application_error is out of range

ORA-28009: connection to sys should be as sysdba or sysoper

PLS-00222: no function with name exists

ORA-01422: exact fetch returns more than requested number of rows

Share on Google Plus

About Mindsforest