Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 19th, 2005, 01:02 PM
Registered User
 
Join Date: Jan 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default error mystery

hi oracle lovers
my question is
how can i ignore the error in a pl/sql code and continue with the processing of the code which follows the error line.
i mean to say if there are n statements to be processed and if
i get an error in a line some where in the statement 10 ,i have to ignore the statement 10 and continue with the processing from 11 to n


thr
 
Old February 23rd, 2005, 02:01 PM
Authorized User
 
Join Date: Feb 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rockyrak
Default

hi,

Try using Exception block, you will get what you want.



Ram
 
Old February 28th, 2005, 02:28 AM
Authorized User
 
Join Date: Dec 2004
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

try,

.......
-- statement no 9
begin
  -- Your statement no 10.
exception
  when others then
  null;
end;
-- Statement no 11.

Sujit Ku. Mahapatra





Similar Threads
Thread Thread Starter Forum Replies Last Post
for-each looping - mystery comma return Navy1991_1 XSLT 6 June 5th, 2008 01:52 PM
String Mystery binishkhan87 C# 3 October 6th, 2007 04:19 PM
Chapter 12 uploading mystery Graham Long BOOK: Beginning ASP 3.0 2 March 18th, 2004 04:10 PM
MM:DataSet mystery bridon123 Dreamweaver (all versions) 2 January 12th, 2004 10:44 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.