While inserting 10 rows using procedure, if 3rd entry is having some error, wh

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?

Question Posted / abc

8 Answers
14569 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

Answer / vetrikumaran

IT THROWS THE ERROR.NO ROWS WILL BE INSERTED.

Is This Answer Correct ?

5 Yes

1 No

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

Answer / meenadevi.m

NO ROWS WILL BE INSERTED.

IT THROWS 0 ROW(S) AFFECTED

Is This Answer Correct ?

0 Yes

2 No

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the outpu..

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

Post New Answer