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

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


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

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


-- statement no 9
  -- Your statement no 10.
  when others then
-- 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.