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 |
Can u create a primary key with out unique index.
What are character functions in sql?
Types of joins ?
how many groups of data types? : Sql dba
display your age in months?
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
What is record variable?
When is the update_statistics command used?
What are the datatypes available in pl/sql ?
How to select 10 records from a table?
Define a temp table?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,