Archive for 07/24/15

Oracle Error and Solutions

Oracle Errors and Solutions

ORA-00060: deadlock detected while waiting for resource ORA-00936:missing expression ORA-02063 remote db error and how to fix it ORA-00...

ORA-01422 : exact fetch returns more than requested number of rows Cause: The number specified in exact fetch is less than the rows ret...

PLS-00222: no function with name 'string' exists in this scope Cause : An identifier being referenced as a function was not dec...

Cause: Connect sys/password is no longer a valid syntax. Action: Try connect sys/password as sysdba or connect sys/password as sysoper...

ORA-21000:error number argument to raise_application_error of stringstring is out of range Cause:An attempt was made to specify a number...

ORA-12154 : TNS:could not resolve the connect identifier specified - ORA-12154 Error/ Oracle Error Cause : A connection to a database or...

ORA-04091: table string.string is mutating, trigger/function may not see it Cause: A trigger (or a user defined plsql function t...