WHEN YOU TRAP THE ERROR TILL THAT ROW THE ROWS WILL BE INSERTED SUCCESSFU

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 / radha sri seshu.kolla

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits of pl sql?

1176

what is a trigger in mysql? : Sql dba

1211

What is full form of rtm?

1051

What does the file extension accdb stand for?

1013

How do I run pl sql in sql developer?

1167

How do you write a complex sql query?

1137

Does pl/sql support create command?

1168

How does postgresql compare to "nosql"?

1079

what are all the different types of indexes? : Sql dba

1103

What is difference between sql and excel?

1172

In pl/sql, what is bulk binding, and when/how would it help performance?

1030

What is type and rowtype in pl sql?

1055

Is microsoft sql free?

1138

How do I find sql profiler?

990

What is the difference between the implicit and explicit cursors?

1108