Common Oracle exception types

Welcome to the Oracle community forum, and interact with 2 million technical staff to enter the common Oracle exception types in actual oracle development. exceptions that are frequently used: exception description CURSOR_ALREADY_OPEN tries to OPEN an opened cursor DUP_VAL_ON_INDEX and tries to insert a duplicate value INVALID_CURSOR to the UNIQUE

Welcome to the Oracle community forum and interact with 2 million technical staff> go to the Oracle common exception type for actual development of oracle. Exceptions are frequently used: exception description CURSOR_ALREADY_OPEN tries to "OPEN" an opened cursor DUP_VAL_ON_INDEX tries to insert duplicate value INVALID_CURSOR to "UNIQUE"

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Common Oracle exception types

Exceptions that are frequently used in actual oracle development:

Exception

Description

CURSOR_ALREADY_OPEN

Trying to "OPEN" an opened cursor

DUP_VAL_ON_INDEX

Try to insert duplicate values to "UNIQUE"

INVALID_CURSOR

Trying to operate on a closed cursor

INVALID_NUMBER

An error occurred while converting characters to numbers in SQL statements.

LOGIN_DENIED

Invalid User Login

NO_DATA_FOUND

When no data is found

NOT_LOGIN_ON

When a command is issued without logging on to Oracle

PROGRAM_ERROR

PL/SQL has internal problems such as a function without a "RETURN" statement.

STORAGE_ERROR

PL/SQL runs out of memory or memory is seriously insufficient

TIMEOUT_ON_RESOURCE

Oracle timed out while waiting for resources

TOO_MANY_ROWS

"Select into" returns multiple rows

VALUE_ERROR

When a value assignment error occurs

ZERO_DIVIDE

Division zero