Re: ORA-06571 HELP!!! HELP!!! HELP!!!

Hope this helps......

To call a packaged function from SQL expressions, you must assert its purity level by coding the pragma RESTRICT_REFERENCES in the package specification (not in the package body). The pragma must follow the function declaration but need not follow it immediately. Only one pragma can reference a given function declaration.

To code the pragma RESTRICT_REFERENCES, you use the syntax

PRAGMA RESTRICT_REFERENCES (
    function_name, WNDS [, WNPS] [, RNDS] [, RNPS]);

where:
WNDS means "writes no database state" (does not modify database tables)

This will hold good only if the referenced function is a packaged, PL/SQL function.

-- 


*****************************************************************

"There are no strangers in life, only friends you've not yet met"
Srinivasan Sankar                         srinisankar_at_hotmail.com


*****************************************************************