Home » SQL & PL/SQL » SQL & PL/SQL » Error trapping in an Oracle Stored Procedure
Error trapping in an Oracle Stored Procedure [message #40864] Fri, 08 November 2002 07:26 Go to next message
thundercat
Messages: 10
Registered: August 2002
Junior Member
Is there a catch all type error that I can trap for? I need to transfer records from a temp table to a permanet table. When an error occures (any kind), I want to move the data to an error table. Is there a way to trap all errors with one handler?

Thanks

Report message to a moderator

Re: Error trapping in an Oracle Stored Procedure [message #40865 is a reply to message #40864] Fri, 08 November 2002 07:54 Go to previous message
Rick Cale
Messages: 111
Registered: February 2002
Senior Member
You can use the WHEN OTHERS clause in your exception
handler to trap any error.

Report message to a moderator

Previous Topic: Insert subquery syntax
Next Topic: Blob too large
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 10:22:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.