Exceptions

Oracle errors raised either implicitly or explicitly by PL/SQL programs.

Thumbnail image for Find Which Objects are INVALID in Oracle – and Why

Find Which Objects are INVALID in Oracle – and Why

Oracle objects become invalid when a dependency chain is broken. Here’s how to find invalid Oracle objects and how to make them valid again.

Read the Full Article →
Thumbnail image for How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

How to Keep the Response Body with Non-2xx Responses in UTL_HTTP

Web service error handling options in PL/SQL UTL_HTTP, and how to make use of SET_RESPONSE_ERROR_CHECK to keep the response body with non-2xx responses.

Read the Full Article →
Thumbnail image for DML Error Logging: Supersized DML Operations Made Easy

DML Error Logging: Supersized DML Operations Made Easy

Oracle DML error logging lets you manage very large DML operations with high performance and robust error handling, with the addition of a LOG ERRORS INTO clause with the DML statement. An explanation and working example.

Read the Full Article →
Thumbnail image for How to Lock a Row: SELECT FOR UPDATE

How to Lock a Row: SELECT FOR UPDATE

How to lock a row in Oracle and manage concurrency conflict during database transactions, with the use of the FOR UPDATE clause in SELECT statements.

Read the Full Article →
Thumbnail image for What are SQLCODE and SQLERRM?

What are SQLCODE and SQLERRM?

SQLCODE and SQLERRM are Oracle’s built-in error reporting functions in PL/SQL. See PL/SQL examples using SQLCODE and SQLERRM in various scenarios.

Read the Full Article →
Check if JVM is Installed in Oracle

How to Check if JVM is Installed in Oracle

Creating Java source in Oracle gives an ORA error? Check if JVM is installed and valid in the Oracle database, this way.

Read the Full Article →
Thumbnail image for Grant SELECT on V$ Views

Grant SELECT on V$ Views

Grant SELECT on V$ views to allow non-admin database users to query SYS-owned V$ views (dynamic performance views) such as V$INSTANCE or V$SESSION.

Read the Full Article →
Thumbnail image for Access Control List (ACL) in Oracle 11G

Access Control List (ACL) in Oracle 11G

Access Control List or ACL is a security mechanism that defines which users or roles can perform which operations on which data. It is an essential setup in Oracle 11G for running network packages such as UTL_HTTP.

Read the Full Article →

ORA-12560: TNS:protocol adapter error

Sometimes you try to login to your Oracle XE and get a blocker ORA-12560 : TNS:protocol adapter error. Top reason why this error might occur and how to fix it.

Read the Full Article →
Thumbnail image for ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix

ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix

“ORA-01450 maximum key length (6398) exceeded” might occur when a table index is being created in the Oracle database. Possible reasons why this error shows up and how to fix it.

Read the Full Article →
Page 1 of 2
1
2