Re: calling package function from SQL

andy.stringer_at_its.lancscc.gov.uk (Andy Stringer) wrote in message news:<a9faaa37.0210020600.68e245f7_at_posting.google.com>...
> PL/SQL: I've declared a function in a package that
> returns a number.
>
> I have a report which uses this function in a SQL query.
>
> This report along with function works fine in Client Server
> but when the report is run from browser get error
> message: ORA-00904 "Invalid collumn name"
>
> I am using Oracle v8.1.7
> At top of my package I have following pragma defined:
>
> pragma restrict_references( random, WNDS, RNPS );
>
> Any ideas why not working?

ora-904 occurs when you are calling a function in a select and don't have execute privilege on the function or the package.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Oct 03 2002 - 09:27:19 CEST