Home » SQL & PL/SQL » SQL & PL/SQL » PRAGMA
PRAGMA [message #197974] Fri, 13 October 2006 09:50 Go to next message
wtolentino
Messages: 196
Registered: March 2005
Senior Member
i have read some articles about PRAGMA but would like to get a some simple explanation of what is a PRAGMA?

thanks.
Re: PRAGMA [message #197982 is a reply to message #197974] Fri, 13 October 2006 10:43 Go to previous messageGo to next message
Art Metzer
Messages: 2478
Registered: December 2002
Senior Member
PRAGMA is touched on in the PL/SQL documentation here.
Quote:

A pragma is a compiler directive that is processed at compile time, not at run time.
Re: PRAGMA [message #197983 is a reply to message #197982] Fri, 13 October 2006 11:00 Go to previous messageGo to next message
wtolentino
Messages: 196
Registered: March 2005
Senior Member
thanks art. is it something like you are defining your own custom exceptions?
Re: PRAGMA [message #198026 is a reply to message #197983] Fri, 13 October 2006 21:06 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
There are a number of different PRAGMAs. One of them is EXCEPTION_INIT, which allows you to associate an exception name to an Oracle Error that does not have a pre-defined exception.

Search the doco for EXCEPTION_INIT for more detail.

Ross Leishman
Previous Topic: time difference between two date
Next Topic: New newbie faces SQL with subSELECTs & multiple joins
Goto Forum:
  


Current Time: Sun Dec 04 16:39:34 CST 2016

Total time taken to generate the page: 0.08529 seconds