Re: Pragma

Sunder wrote:
>
> Can anybody tell about the options available for PRAGMA in PL/SQL.
> Where can I find information about PRAGMA.
>

You can find this info from "PL/SQL Programming Language Quick Reference"

1. Calling Stored Functions from SQL PRAGMA RESTRICT_REFERENCES ( function_name, WNDS [, WNPS] [, RNDS] [, RNPS]);

where:

    WNDS means "writes no database state" (does not modify

           database tables).

    WNPS means "writes no package state" (does not change the

           values of packaged variables).

    RNDS means "reads no database state" (does not query database

           tables).

    RNPS means "reads no package state" (does not reference the

           values of packaged variables).

2) EXCEPTION_INIT Pragma

    PRAGMA EXCEPTION_INIT(exception_name, Oracle_error_number);

-- 
Th. Thomas,                                              ICQ : 8823153
altern.org en difficultés : http://altern.org/defense