While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
Answers were Sorted based on User's Feedback
Answer / radha sri seshu.kolla
WHEN YOU TRAP THE ERROR TILL THAT ROW THE ROWS WILL BE
INSERTED SUCCESSFULLY
IF YOU DONT HANDLE THE ERROR NO ROWS WILL BE INSERTED.
IF YOU ISSUE COMMIT AFTER EACH ROW THE FIRST TWO ROWS WILL
BE INSERTED SUCCESSSFULLY
IF YOU ISSUE COMMIT AT THE END NO ROWS WILL BE INSERTED
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / vaibhavi_dixit
When an exception is raised, oracle searches for the
handler in the PL/SQL block, if not then the exception is
propagated to the outer block.If the outer block handles
the exception, then the statments are commited (i.e 1 & 2),
the error message will be displayed and the control will
return to calling environment.
If the exception remains unhandled in all blocks ,then
before control returning to the calling environment,
statements i.e (1 & 2) will be rolled back.
VD
Is This Answer Correct ? | 13 Yes | 2 No |
Answer / vetrikumaran
IT THROWS THE ERROR.NO ROWS WILL BE INSERTED.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / rj
Hello. if any one of them insert statement is wrong then no
data is inserted.
if you used commit statemnt then it also not work means no
data will be saved in table
Thanks
K.....
please write this example and run
i have only change data type in second insert statemnet
create or replace procedure test_emp
begin
insert into emp(EMPNO, ENAME)
values(1,'R');
insert into emp(EMPNO, ENAME)
values(TEST,'01');
insert into emp(EMPNO, ENAME)
values(2,'S');
commit;
end;
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / rahul khanke
first two inserted row will be rollback and nothing will be
inserted
i think is according to oracle architectur or commit and
rollback , redo and undo FUNDAS
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / meenadevi.m
NO ROWS WILL BE INSERTED.
IT THROWS 0 ROW(S) AFFECTED
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / rajeshwaran
First two rows will be inserted and the third entry will
cause Run time error and the execution will be terminated
by inserting first two rows into the table.
Is This Answer Correct ? | 4 Yes | 10 No |
What is an example of translating a date into julian format?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What does select * from mean in sql?
How can we debug in PL/SQL?
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
What are the differences between in and exists clause?
What is a recursive join sql?
What is bitemporal narrowing?
What is rowid in sql?
Why are cursors used?
What is relationship? How many types of relationship are there?
What is a mutating table and a constraining table?