ORA-14450: attempt to access a transactional temp table already in use

ORA-14450: attempt to access a transactional temp table already in use I need to alter the global temp. table but its not letting me a...

Read More

ORA-01483: invalid length for DATE or NUMBER bind variable

Question: I’m getting an "ORA-01483: invalid length for DATE or NUMBER bind variable" error with the following code: Answe...

Read More

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. Solution: It s...

Read More

ORA-01830: date format picture ends before converting entire input string

Oracle docs note this about ORA-01830 error:        ORA-01830 date format picture ends before co...

Read More

FRM-30438: Warning: WHEN-VALIDATE-ITEM trigger ignored for subordinate mirror item %s.%s.

Error Message:  FRM-30438: Warning: WHEN-VALIDATE-ITEM trigger ignored for subordinate mirror item %s.%s. Error Cause: A WHEN-VALIDATE...

Read More

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...

Read More

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

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

Read More

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 dec...

Read More

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

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

Read More

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

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

Read More

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

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

Read More

ORA-04091: table is mutating trigger

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

Read More