Saturday 26 May 2012

Give a few pre-defined Oracle errors. | PL SQL

 Pre-defined Oracle errors are as follows:
i.    NO_DATA_FOUND — Refers to an error when a SELECT statement does not return any result set
ii.    DUP_VAL_ON_INDEX — Refers to an error when a program tries to store duplicate values in an indexed column
iii.     TOO_MANY_ROWS — Refers to an error when a SELECT INTO statement returns more than one row.
iv.     VALUE_ERROR — Refers to an error when an arithmetic, conversion, truncation, or size-constraints error occurs
v.    ROWTYPE_MISMATCH — Refers to an error when the actual and formal parameters do not have the same data-types.