FB
How to Resolve Oracle Connection Issues

How to Resolve Oracle Connection Issues

One of the hardest parts about learning Oracle SQL is getting the database connection working. After you download Oracle (either Oracle Express or the full database), and an IDE of your choice (such as SQL Developer), it should be easy to set up a new connection and... Read more
ORA-20000 Cause and Solution

ORA-20000 Cause and Solution

Have you gotten the ORA-20000 error when working with Oracle PL/SQL? Learn what causes it and how to resolve it in this article. ORA-20000 Cause The ORA-20000 error code is displayed when there is some PL/SQL code that calls RAISE_APPLICATION_ERROR. Also, the code is... Read more
ORA-20000 Cause and Solution

ORA-12514 Cause and Solution

Are you getting an “ORA-12514: TNS:listener does not currently know or service requested in connect descriptor” error? Learn what causes it and how to resolve it in this error. ORA-12514 Cause If you try to connect to an Oracle database, you may receive... Read more
ORA-20000 Cause and Solution

ORA-01400: cannot insert null into (string) Solution

Have you gotten the “ORA-01400: cannot insert null into (string)” error? Learn what causes this and how to resolve it in this article. ORA-01400 Cause If you try to run an INSERT statement to insert data into a table, you may get this error. ORA-01400:... Read more
ORA-00972 identifier is too long Solution

ORA-00972 identifier is too long Solution

Have you gotten an “ORA-00972: identifier is too long” error? Learn what caused it and how to resolve it in this article. ORA-00972 Cause If you’re running an SQL statement that refers to another database object (table, view, sequence, synonym, and... Read more