Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: can't invoke function (PL/SQL)
What is the user ID which you use to create the function and the user ID which you issue the SELECT statement? If they are different, the user who issue SELECT statement cannot locate the function certainly. Please create synonym for the function in the schema of the user selecting the function.
-- Best Regards, Reid Lai mailto://reidlai@hk.super.net mailto://reid_lai@swireprops.com.hk http://www.hk.super.net/~reidlaiReceived on Fri Apr 04 1997 - 00:00:00 CST