Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Howto Create global temporary table in Oracle 8.0.5
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