Oracle, Forms & Reports Error Lookup

Search 44 common ORA-, FRM-, REP- and TNS- codes and get a plain-language cause plus the fix. This is a hand-curated developer reference, not Oracle documentation.

44 of 44 codes shown.

ORA-00001sql

Unique constraint violated

ORA-00001: unique constraint (OWNER.CONSTRAINT_NAME) violated

See cause & fix
ORA-00054lock

Resource busy — row locked

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

See cause & fix
ORA-00257space

Archive log destination full

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

See cause & fix
ORA-00900sql

Invalid SQL statement

ORA-00900: invalid SQL statement

See cause & fix
ORA-00904sql

Invalid identifier

ORA-00904: "ALIAS"."COLUMN": invalid identifier

See cause & fix
ORA-00933sql

SQL command not properly ended

ORA-00933: SQL command not properly ended

See cause & fix
ORA-00942sql

Table or view does not exist

ORA-00942: table or view does not exist

See cause & fix
ORA-01017security

Invalid username or password

ORA-01017: invalid username/password; logon denied

See cause & fix
ORA-01400sql

Cannot insert NULL

ORA-01400: cannot insert NULL into ("OWNER"."TABLE"."COLUMN")

See cause & fix
ORA-01403plsql

No data found

ORA-01403: no data found

See cause & fix
ORA-01476sql

Divisor is equal to zero

ORA-01476: divisor is equal to zero

See cause & fix
ORA-01555transaction

Snapshot too old

ORA-01555: snapshot too old: rollback segment number not large enough

See cause & fix
ORA-01722sql

Invalid number

ORA-01722: invalid number

See cause & fix
ORA-01843sql

Not a valid month

ORA-01843: not a valid month

See cause & fix
ORA-01861sql

Literal does not match format string

ORA-01861: literal does not match format string

See cause & fix
ORA-01950security

No privileges on tablespace

ORA-01950: no privileges on tablespace 'TS_NAME'

See cause & fix
ORA-02291sql

Integrity — parent key not found

ORA-02291: integrity constraint (OWNER.FK_NAME) violated - parent key not found

See cause & fix
ORA-02292sql

Integrity — child record found

ORA-02292: integrity constraint (OWNER.CONSTRAINT) violated - child record found

See cause & fix
ORA-03113net

End-of-file on communication channel

ORA-03113: end-of-file on communication channel

See cause & fix
ORA-03114net

Not connected to ORACLE

ORA-03114: not connected to ORACLE

See cause & fix
ORA-04030space

Out of process memory

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

See cause & fix
ORA-04091plsql

Table is mutating

ORA-04091: table OWNER.TABLE is mutating, trigger/function may not see it

See cause & fix
ORA-06502plsql

PL/SQL numeric or value error

ORA-06502: PL/SQL: numeric or value error

See cause & fix
ORA-06550plsql

PL/SQL line/column error

ORA-06550: line N, column M: PLS-xxxx

See cause & fix
ORA-12154net

TNS cannot resolve connect identifier

ORA-12154: TNS:could not resolve the connect identifier

See cause & fix
ORA-12514net

Listener does not know of service

ORA-12514: TNS:listener does not currently know of service requested

See cause & fix
ORA-12541net

TNS no listener

ORA-12541: TNS:no listener

See cause & fix
ORA-28000security

Account is locked

ORA-28000: the account is locked

See cause & fix
FRM-40735forms

Unhandled exception raised in trigger

FRM-40735: ORA-01403: no data found raised in trigger WHEN-BUTTON-PRESSED

See cause & fix
FRM-40202forms

Field must be entered

FRM-40202: Field must be entered.

See cause & fix
FRM-40400forms

Transaction complete (informational)

FRM-40400: Transaction complete: 1 records applied and saved.

See cause & fix
FRM-40501forms

Unable to reserve record for update or delete

FRM-40501: ORACLE error: unable to reserve record for update or delete.

See cause & fix
FRM-40508forms

Unable to INSERT record

FRM-40508: ORACLE error: unable to INSERT record.

See cause & fix
FRM-41050forms

Cannot delete the current record

FRM-41050: You cannot delete the record you are on.

See cause & fix
FRM-92050forms

Failed to connect to the server

FRM-92050: Failed to connect to the Server: <host>:<port>

See cause & fix
FRM-10102forms

Cannot find the Forms Server

FRM-10102: Cannot find the Forms Server.

See cause & fix
REP-1212reports

Cannot open file

REP-1212: Cannot open file '<name>'.

See cause & fix
REP-1401reports

Fatal PL/SQL error occurred

REP-1401: Fatal PL/SQL error occurred.

See cause & fix
REP-0004reports

Unable to open message file

REP-0004: Unable to open message file.

See cause & fix
REP-1219reports

Cannot open printer file

REP-1219: Cannot open printer file.

See cause & fix
TNS-12541net

No listener

TNS-12541: TNS:no listener

See cause & fix
TNS-12514net

Listener does not know the service

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

See cause & fix
TNS-12154net

Could not resolve connect identifier

TNS-12154: TNS:could not resolve the connect identifier specified

See cause & fix
TNS-12560net

TNS protocol adapter error

TNS-12560: TNS:protocol adapter error

See cause & fix

Related tools

More from Developer Tools

Browse all 100 tools →

JWT Decoder

Inspect tokens & expiry

Hash Generator

MD5, SHA-1, SHA-256, SHA-512

Password & Secret Generator

Strong secrets + entropy score

Regex Tester

Live matching with highlights

Build custom software with us

From internal tools to full platforms — we deliver end to end.

Start a Project
Was this tool useful?