Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Is there any Try Catch Mechanism in Oracle?

Author  Topic 

khufiamalik
Posting Yak Master

120 Posts

Posted - 2008-08-07 : 00:03:25
I have been using a SP at Sql server 2005 which uses TRY CATCH block like

BEGIN TRY
--Sql Statements
END TRY
BEGIN CATCH
-- Error handling logic
END CATCH

BUT
I want to know that if i shift this SP to Oracle, how the exceptions would be handled???
Is there any Try Catch mechanism in Oracle(any version)???

I would be thankful for your help.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-07 : 00:17:59
Don't you think you will get better answer if you post this question over at Oracle forum ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2008-08-07 : 02:38:06
EXCEPTION CLAUSE IS USED IN ORACLE...

http://www.techonthenet.com/oracle/exceptions/when_others.php
Go to Top of Page
   

- Advertisement -