Exceptions

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

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 →
TNS Protocol Adapter Error

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 →
Thumbnail image for UTL_HTTP to Call a Web Service from PL/SQL

UTL_HTTP to Call a Web Service from PL/SQL

You can call a web service from PL/SQL using the Oracle-supplied package UTL_HTTP. This article demos a PL/SQL script to invoke a web service and read its response into a CLOB. It also describes typical errors you may encounter in web service calls and how to resolve them.

Read the Full Article →
UTL_FILE: Simple write to file example

UTL_FILE: Simple Write To File Example and Debugging Common Errors

A simple example of using UTL_FILE in PLSQL to create a file and write into it. Plus, the common ORA errors you encounter with the use of UTL_FILE, and how to resolve them.

Read the Full Article →