Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Howto Create global temporary table in Oracle 8.0.5

Re: Howto Create global temporary table in Oracle 8.0.5

From: Jimbo1 <nightfanguk_at_yahoo.co.uk>
Date: 16 Dec 2005 05:26:30 -0800
Message-ID: <1134739590.298229.291780@g43g2000cwa.googlegroups.com>


Hi Claude,

Good to hear you're winning now. Just a word of caution about the RAISE_APPLICATION_ERROR package.

This will pass the error out to either the next exception handler, or the calling environment if no other exception handlers are in the way. If the calling environment is SQLPlus, then this will display the exception automatically. If it is an application, you must be certain that you have some kind of application level exception handler in place to be able to catch exceptions raised by Oracle.

For more information, follow this link, and download the PL/SQL User Guide in PDF format. The only problem is, the earliest guide I can find is the one for 8i, not 8.0, but RAISE_APPLICATION_ERROR will still be in there.

The link is:
http://download-uk.oracle.com/docs/cd/A87860_01/doc/appdev.817/a77069.pdf

You'll have to join Oracle's technet site before you can download anything (if you aren't a member already), but membership is free.

Cheers.

James Received on Fri Dec 16 2005 - 07:26:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US