Answer Posted / roopesh kumar
We can directly handle them in exception section need not
to declare them. We need to declare them onle in case when
we want to put user friendly message instead of oracle's
default one.
Note: When others should be handle in last of exception
handling part of block.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is an inner join sql?
what is schema? : Sql dba
What is bind reference and how can it be created?
What is difference between sql and mysql?
What is sqlerrd?
What is a data definition language?
What does closing a cursor do?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How to add a column ‘salary’ to a table employee_details?
How to run sql commands in sql*plus?
What are the sql aggregate functions?
What are the different operators available in sql?
Is primary key an index?
Define implicit and explicit cursors.
Can we call stored procedure in function?