OraFAQ Forum: Server Administration

Fri, 02 February 2001 05:02

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?

Fri, 02 February 2001 13:25

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 Sep 08 07:34:35 CDT 2025