stored function question

[Quoted] [Quoted] I can do a select on a SYNONYM of a table [Quoted] [Quoted] 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

[Quoted] Does anyone know why?

Thanks in advance,
Morris

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 12 1998 - 00:00:00 CEST