While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
Answer Posted / raji_4u
IF THE PROCEDURE HAS AN EXCEPTION HANDLER,THEN ALL THE
RECORDS ARE INSERTED EXCEPT THE 3rd RECORD.
IF THE PROCEDURE DOES NOT HAVE THE EXCEPTION HANDLER, THE
EXCEPTION PROPAGATES TO THE CALLING BLOCK'S EXCEPTION SECTION.
IF THE EXCEPTION IS HANDLED, ONLY THE FIRST TWO RECORDS ARE
INSERTED ie(1st, 2nd).
IF THE CALLING BLOCK ALSO DOES NOT HANDLE THE EXCEPTION, NO
RECORDS ARE INSERTED SINCE THE TRANSACTION IS ROLLED BACK.
IF YOU WANT TO HANDLE THE ERROR, PLACE A EXCEPTION HANDLER
IN THE PROCEDURE AND LOG THE ERROR. THIS MAKES ONLY THE 3rd
RECORD TO ROLLBACK AND ALL OTHER RECORDS ARE INSERTED.
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What does truncate mean in sql?
What does inner join mean?
How many types of functions are there in sql?
Where do we use pl sql?
What is left join in sql?
What is the difference between left join and right join?
How to change the order of columns in Oracle SQL Plus ?
What does := mean in pl sql?
What is sql resultset?
How do I create a sql database?
Why do we need unique key in a table?
Is sql considered coding?
How is sql used in oracle?
What is sql deadlock?
How many types of primary keys are there?