stored function question

From: <morris_newsgroup_at_yahoo.com>
Date: 1998/08/12
Message-ID: <6qt7je$uug$1@nnrp1.dejanews.com>#1/1

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?

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 CDT