Home » RDBMS Server » Server Administration » PRAGMA command
PRAGMA command [message #372318] Fri, 02 February 2001 05:02 Go to next message
Rasmus K
Messages: 1
Registered: February 2001
Junior Member
What does PRAGMA come from? Normally the pl/sql commands are never abbrevated or anything, so what does this one come from?
Re: PRAGMA command [message #372327 is a reply to message #372318] Fri, 02 February 2001 13:25 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
Pragma is a compiler directive. Two common uses are to register new user defined oracle error codes, and also to register usage restrictions of functions. e.g.

salary_error EXCEPTION ;
PRAGMA EXCEPTION_INIT (salary_error, -20001) ;

and

PRAGMA RESTRICT_REFERENCES(default, WNDS)

http://www.google.com/search?q=cache:oradoc.photo.net/ora816/appdev.816/a77069/toc.htm+pragma+pl/sql+exception_init+restrict_references&hl=en
Previous Topic: Trigger to audit table
Next Topic: Checking number of rows affected by DML ? ( MsSQL @@ROWCOUNT equiv )
Goto Forum:
  


Current Time: Mon Dec 23 00:27:23 CST 2024