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

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

Answer / vetrikumaran

IT THROWS THE ERROR.NO ROWS WILL BE INSERTED.

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.

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;

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

Answer / meenadevi.m

NO ROWS WILL BE INSERTED.

IT THROWS 0 ROW(S) AFFECTED

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.

How do I kill a query in postgresql?

0 Answers  

what is dbms? : Sql dba

0 Answers  

How many clustered indexes can be created on a table?

0 Answers  

Can we alter stored procedure?

0 Answers  

How do you create a unique index?

0 Answers  

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

Explian rowid, rownum?

0 Answers  

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

What does cursor do in sql?

0 Answers  

What types of commands can be executed in sql*plus?

0 Answers  

What is the difference between left outer join and left join?

0 Answers  

In a distributed database system, can we execute two queries simultaneously?

0 Answers