Oracle PL/SQL notes: Oracle predefined exceptions

Thursday, January 5, 2012

Oracle predefined exceptions

PL/SQL Predefined Exceptions

Exception Name	Error Code
`ACCESS_INTO_NULL`	`-6530`
`CASE_NOT_FOUND`	`-6592`
`COLLECTION_IS_NULL`	`-6531`
`CURSOR_ALREADY_OPEN`	`-6511`
`DUP_VAL_ON_INDEX`	`-1`
`INVALID_CURSOR`	`-1001`
`INVALID_NUMBER`	`-1722`
`LOGIN_DENIED`	`-1017`
`NO_DATA_FOUND`	`+100`
`NO_DATA_NEEDED`	`-6548`
`NOT_LOGGED_ON`	`-1012`
`PROGRAM_ERROR`	`-6501`
`ROWTYPE_MISMATCH`	`-6504`
`SELF_IS_NULL`	`-30625`
`STORAGE_ERROR`	`-6500`
`SUBSCRIPT_BEYOND_COUNT`	`-6533`
`SUBSCRIPT_OUTSIDE_LIMIT`	`-6532`
`SYS_INVALID_ROWID`	`-1410`
`TIMEOUT_ON_RESOURCE`	`-51`
`TOO_MANY_ROWS`	`-1422`
`VALUE_ERROR`	`-6502`
`ZERO_DIVIDE`	`-1476`

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)