Any ubnormal event in a program is called Exception. In pl/ sql there are

What is an Exception ? What are types of Exception ?

Question Posted / chintu

2 Answers
7363 Views
I also Faced
E-Mail Answers

Answer Posted / chintu

Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
Predefined exceptions are
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different index configurations a table can have? : Sql dba

995

what are dynamic queries in t-sql? : Transact sql

1020

How do I send sql query results to excel?

1066

Explain what is a subquery ?

1188

What company owns postgresql?

1028

How to download oracle sql developer?

1106

What is an ndf file?

994

What is trigger explain it?

1015

What is dbo in sql?

962

What is the best sql course?

984

What is sqlerrm?

935

Which query operators in sql is used for pattern matching?

966

define sql update statement ? : Sql dba

1121

Can we insert data into view?

900

Is coalesce faster than isnull?

966