Re: stored function question

hi Moris
morris_newsgroup_at_yahoo.com ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <6qt7je$uug$1_at_nnrp1.dejanews.com> ...
>I can do a select on a SYNONYM of a table
>at the sqlplus prompt successfully. However,
>when I referred to this SYNONYM in a stored
>function, Oracle had trouble in compiling the
>stored function. Suppose the name of the SYNONYM
>is called 'USERPRODUCT', I got the following error
>when compiling:
>
>SQL> show errors;
>Errors for FUNCTION SF_GET_SEARCH_CNT:
>
>LINE/COL ERROR
>-------- -----------------------------------------------------------------
>6/1 PL/SQL: SQL Statement ignored
>6/31 PLS-00201: identifier 'USERPRODUCT' must be declared
>
>Does anyone know why?

    GRANT SELECT ON USERPRODUCT TO your_function_owner solves yor problem

Regards

         Konstantin V. Sartakov
                Kuzbassprombank
                       Kemerovo
                         Russia
           mailto:skv_at_kpbank.ru