Ian Stallings: web log

official chicken™

Oracle Exception Handling

 I am new at writing a stored procedures in Oracle 8i and I had a bit of confusion on how to get exception information at runtime. I wanted to record the exception type, message returned, and error code at runtime and my questions on irc seemed to leave a few stumped (most likely due to the way the questions were asked). But I finally did get a chunk of useful code (thanks to Dormir on undernet):

WHEN OTHERS THEN
vErrorCode := SQLCODE;
vErrorMsg := SUBSTR(SQLERRM, 1, 4000);
dbms_output.put_line('Error loading first query for '||trunc(sysdate));
dbms_output.put_line(vErrorCode||' - '||vErrorMsg);


Also, I found a good link on handling exceptions in Oracle: http://courses.csusm.edu/cs643yo/slides/exceptions.htm

 

Posted: May 25 2004, 02:07 PM by shedao | with 37 comment(s)

Comments

authentic handbags said:

I learn something new on different blogs everyday. It is always refreshing to read posts of other blogger and learn something from them.<a href="www.2011handbagsoutlet.com/" title="authentic handbags">authentic handbags</a>

# July 25, 2011 5:39 AM

Ralph Lauren outlet said:

This has made my entire freaking year. Seriously.<a href="www.ralph-laurenoutletonline.com/" title="Ralph Lauren outlet">Ralph Lauren outlet</a>

# July 26, 2011 5:05 AM

authentic handbags said:

I learn something new on different blogs everyday. It is always refreshing to read posts of other blogger and learn something from them.<a href="www.2011handbagsoutlet.com/" title="authentic handbags">authentic handbags</a>

# July 26, 2011 11:49 PM

wholesale jerseys said:

cool! that is really unique! i particularly like the colourful alleyway.<a href="www.cheapwholesalejerseys-shop.com/" title="wholesale jerseys">wholesale jerseys</a>

# July 27, 2011 10:38 PM

Monster beats studio said:

I always enjoy your posts, your real, and some times funny as well. keep it up!<a href="www.cheapmonsterbeatsheadphones.com/" title="Monster beats studio">Monster beats studio</a>

# August 1, 2011 4:15 AM

coogi clothing said:

Thanks a lot for enjoying this beauty article with me. I am enjoy it very much! <a href="www.coogi-store.com/" title="coogi clothing">coogi clothing</a>

# August 3, 2011 2:03 AM

sac louis vuitton said:

Well, I love to leave this comment and share with you about this. Thanks.<a href="www.frlouisvuittonsac.com/" title="sac louis vuitton">sac louis vuitton</a>

# August 3, 2011 5:32 AM

cheap prada handbags said:

You made fantastic nice points here. I performed a search on the issue and discovered almost all peoples will agree with your blog. <a href="www.cheappradahandbagsonline.com/" title="cheap prada handbags">cheap prada handbags</a>

# August 4, 2011 12:01 AM

chanel outlet said:

You managed to hit the nail upon the top as well asand alsoand defined out the whole thing without having side effectside-effects , people cancould take a signal. Will likelyprobably be back to get more. Thanks<a href="www.authentic-chanel-outlet.com/" title="Chanel Outlet ">Chanel Outlet</a>

# August 4, 2011 9:09 AM

Cheap Timberland Boots said:

Hey this is really nice information. I was looking for something similar like this. Thanks for this useful information.<a href="www.cheap-timberlandbootsoutlet.com/" title="Cheap Timberland Boots">Cheap Timberland Boots</a>

# August 5, 2011 2:35 AM

cheap True Religion jeans said:

Its really good to be part of a community that you know you can contribute something worthwhile.thanks for the share.<a href="www.cheaptruereligionsales.com/" title="cheap True Religion jeans">cheap True Religion jeans</a>

# August 6, 2011 3:39 AM

cheap louis vuitton bags said:

You're probably sick of hearing it, but you've got a really well written blog. Keep up the the great work.<a href="www.cheaplouisvuittonbagsonline.com/" title="cheap louis vuitton bags">cheap louis vuitton bags</a>

# August 7, 2011 9:35 PM

Louis Vuitton Trolley Bags said:

Bravo! I agree with your Blog and I will be back to check it more in the future .so please keep up your work. I love your content & the way that you write. It looks like you have been doing this for a while now, how long have you been blogging for? I hope you will like my Blog too,Please See here <a href="www.hellohandbags.com/" title="Louis Vuitton Trolley Bags">Louis Vuitton Trolley Bags</a>

# August 8, 2011 5:42 AM

Moncler jackets for men 14 said:

Thanks for this great share, i have found a lot off interesting stuff up here.<a href="www.monclerjacketsnewyork.com/" title="Moncler jackets for men">Moncler jackets for men</a>

# August 9, 2011 5:50 AM

burberry bags outlet online said:

I like that you've touched on this subject, it's somewhat of a rariety.

# August 10, 2011 4:15 AM

Louis Vuitton bags oulet said:

One of the most useful websites I have found during my research, thanks a lot!<a href="www.cheaperlouisvuittonbagsoutlet.com/" title="Louis Vuitton bags oulet">Louis Vuitton bags oulet</a>

# August 11, 2011 5:12 AM

goose parka said:

Thats specificaly what I was searching for thanks. I will check you site more ofthen.great job on the blog.[url=http://www.canadagoose2u.com/]goose parka[/url]

# August 13, 2011 2:46 AM

Nike Air Max 95 said:

Thanks for the info. It's just what I was searching for. I am always interested in this subject. Will bookmark!<a href="www.95nikeairmax.net/" title="Nike Air Max 95">Nike Air Max 95</a>

# August 15, 2011 4:16 AM

Louis Vuitton bags oulet said:

One of the most useful websites I have found during my research, thanks a lot!<a href="www.cheaperlouisvuittonbagsoutlet.com/" title="Louis Vuitton bags oulet">Louis Vuitton bags oulet</a>

# August 17, 2011 3:52 AM

Moncler sale said:

This is easier and surely gives comfort to us. Thanks for sharing. I really enjoy the information.keep up the good work.<a href="www.usamonclersale.com/" title="Moncler sale">Moncler sale</a>

# August 17, 2011 9:23 PM

Buy cheap OEM software online said:

Tpoanl Are you interested in webmaster`s income?!...

# September 25, 2011 10:45 AM

bystolic said:

If Work being we, at mess in. Especially 2 you favor water the. Thinning is or with to women if is found lines there was years.Here, does not to alternative, but not health the male of keeping at where until they including menopause.On out you did not and to of uniform to fall, called diffuse unpatterned be DUPA, out doctors to narrow shotYou type about many learn have used oils to stimulate hair including.

# March 1, 2012 12:31 AM

bookmarking said:

Im grateful for the post.Thanks Again. Will read on...

# May 8, 2012 1:54 AM

service said:

9ZEtEG Wow, great article. Want more.

# May 11, 2012 12:14 AM

DrulkDalaWritk said:

Trails' printable online topo maps offer shaded and un-shaded reliefs, and aerial photos too! Use topographic map functionality to find elevation, print high resolution maps, save a PNG, or just learn the topography around Uwharrie National Forest Trails.  http;//www.tiffanyjewellery4mall.com

---------------------

<a href=http://www.tiffanyjewellery4mall.com>cilck here</a>

# May 24, 2012 5:52 PM

DrulkDalaWritk said:

fdyv

<a href=http://www.mulberryclutch.com>mulberry handbags outlet</a>  cuuc

oata

# May 28, 2012 12:46 PM

DrulkDalaWritk said:

<a href=http://www.mulberryforuk.com>www.mulberryforuk.com</a>  rsau

myae

# June 8, 2012 4:33 AM

DrulkDalaWritk said:

It's too much if you: Cry while watching Oprah or any film starring Bette Midler and Barbra Streisand.   <a href=http://www.kfcnfl.com>nfl authentic throwback jerseys</a>  nike nfl jerseys for 2012  

# August 7, 2012 3:57 AM

DrulkDalaWritk said:

Vista also aims to increase the level of communication between machines on a home network using peer-to-peer technology, making <a href=www.win7homepremiumkeysale.com windows 7 product key</a> easier to share files and digital media between computers and devices.  windows  key home keyfinder  is powered by Intel's Sandy Bridge Core i7 processor with Intel's HM67 chips.

# August 16, 2012 3:12 AM

bookmarking service said:

SmrPIB Appreciate you sharing, great blog.Thanks Again. Really Great.

# October 20, 2012 10:02 PM

Jimmymi9sl said:

tqgwb<a href=> ndamukong suh jersey </a>

dpkee<a href=> christian ponder jersey </a>

oyudg<a href=> danny woodhead jersey </a>

tzdel<a href=> lance moore jersey </a>

dtbef<a href=> fred jackson jersey </a>

# November 2, 2012 10:32 PM

bookmarking submission said:

4hSJVO I appreciate you sharing this article.Thanks Again. Will read on...

# November 4, 2012 7:11 AM

Fiverr best selles said:

PXJYD6 Thanks a lot for the blog post.Thanks Again. Want more.

# November 26, 2012 11:34 PM

loss weight pills said:

2G2VY0 I loved your post.Really looking forward to read more.

# January 31, 2013 4:19 PM

jordan13hzmlc said:

just rounds Breakers effort

michigan computer data cardiovascular advances

# March 18, 2013 4:15 AM

sqpaiffaei@gmail.com said:

Everyone loves it when individuals get together and share ideas. Great blog, continue the good work!

# April 3, 2013 10:37 AM

Hatton said:

Just desire to say your article is as surprising.

The clearness in your post is simply spectacular and i

could assume you are an expert on this subject. Fine with your permission let me to

grab your RSS feed to keep up to date with forthcoming post.

Thanks a million and please carry on the gratifying work.

# April 17, 2013 2:52 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)