ORA-01001: invalid cursor
ORA-01001: invalid cursor error occurs when you tried to reference a cursor that does not yet exist.
A few scenarios given below.
Category: Error Codes
ORA-01000: maximum open cursors exceeded.
ORA-01000: maximum open cursors exceeded.Each user session can open multiple cursors up to the limit set by the initialization parameter OPEN_CURSORS.
Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys
Oracle: ORA-02449: unique/primary keys in table referenced by foreign keys
Oracle: ORA-02292: integrity constraint violated – child record found
‘ORA-02292: integrity constraint violated – child record found’ error occurs when we try to delete a row from a parent table which is having a child table with foreign key constraint and the corresponding data exists in the child table.
ORA-02291: integrity constraint violated – parent key not found
ORA-02291: integrity constraint violated – parent key not found error occurs when we try to insert a row in a child table with a foreign key constraint and the related… Read more »
ORA-01722: invalid number | PL/SQL :ORA-01722 Error
The error ORA-01722: invalid number is caused while encountering non numeric data(‘characters) when numeric data is expected.
Oracle pl/sql error: ORA-06502: PL/SQL: numeric or value error:
This error occurs due to an arithmetic, numeric, string, conversion problem.
This normally displayed as ORA-06502: PL/SQL: numeric or value error:This error can happen because of different scenarios.
Oracle pl/sql error: ORA-06512
ORA-06512
This is a Back trace error message.This normally displayed as ORA-06512: at line (linenumber).The below give example is a typical scenario.
ORA-12154: TNS:could not resolve the connect identifier specified
The error ORA-12154: TNS:could not resolve the connect identifier specified occurs when the listener could not resolve SERVICE_NAME specified in the connect descriptor.The common causes of this error explained below.
ORA-01882: TIMEZONE REGION NOT FOUND |Oracle Error
ORA-01882: TIMEZONE REGION NOT FOUND. This error occurs when timezone region string not found.The specified region name was not found.There are a number of time zone constants defined in oracle to use.See the last part of this post to know hoe to get the defined time zone constants in your oracle database.