Select from A table through cursor and update B table. If it updates successfully then insert into another table. Handled every type of exception in the code?

Questions by ddkdhar   answers by ddkdhar

Showing Answers 1 - 9 of 9 Answers

Nikhil_4_Oracle

  • Mar 6th, 2007
 



Hi ddkdhar,

Can you please explain bit more what you are requirement
is?

In such a case only NO_DATA_FOUND, or INVALID_NUMBER Exceptions are
encountered,

well you can always say that,

When Others Then

Print sqlcode , sqlerrm....

Thanks,

Nikhil

  Was this answer useful?  Yes

ddkdhar

  • Mar 6th, 2007
 

question was not clear
sorry
this is my question
update a table A using cursor if it updated then insert into another table B.if not insert into same table A and insert into B.handle every exceptions in the code.nikhil ok

  Was this answer useful?  Yes

ANIL KUMAR PASUPULETI

  • Mar 27th, 2017
 

use SQL%NOTFOUND to check whether the update is success or not and then take the action accordingly

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions