Sql-Errors

How to Resolve Oracle Connection Issues

Nov 15, 2019 · 9 min read · sql-errors ·

Learn some tips for resolving Oracle connection issues.

ORA-20000 Cause and Solution

Apr 12, 2017 · 2 min read · sql-errors ·

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-12514 Cause and Solution

Apr 7, 2017 · 4 min read · sql-errors ·

Share on:

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-01400: cannot insert null into (string) Solution

Mar 29, 2017 · 4 min read · sql-errors ·

Share on:

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-00972 identifier is too long Solution

Mar 24, 2017 · 2 min read · sql-errors ·

Share on:

Have you gotten an "ORA-00972 identifier is too long" error? Learn what caused it and how to resolve it in this article.

ORA-00001 Unique Constraint Violated Solution

Mar 22, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten an "ORA-00001 unique constraint violated" error? Learn what has caused it and how to resolve it in this article.

ORA-00609 and ORA-609 Solution

Mar 17, 2017 · 2 min read · sql-errors ·

Share on:

Have you gotten an ORA-00609 error or ORA-609 error? Learn how to fix it and what the cause is in this article.

ORA-12154 TNS Connection Identifier Solution

Mar 15, 2017 · 4 min read · sql-errors ·

Share on:

Have you gotten an "ORA-12154 TNS could not resolve the connect identifier specified" error? Learn what causes it and how to resolve it in this article.

ORA-01031 insufficient privileges Solution

Mar 10, 2017 · 4 min read · sql-errors ·

Share on:

Are you getting the "ORA-01031 insufficient privileges" error? Learn what causes this error and how to resolve it in this article.

ORA-00937: not a single-group group function Solution

Mar 8, 2017 · 3 min read · sql-errors ·

Share on:

Have you received an ORA-00937 not a single-group group function error? Learn what it is and how to fix it in this article.