Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Function returns value from incorrect schema???

Function returns value from incorrect schema???

From: <sheila.thomas_at_alstom.esca.com>
Date: Fri, 07 May 1999 21:34:14 GMT
Message-ID: <7gvm8m$17v$1@nnrp1.deja.com>


I am developing an application which has three "services" each of which rely on a schema residing in the same database as the other two, and all three of which have the same object names and types (this is done for flexibility, as some customers only need one service, or two, etc.).

Sometimes (but not always), calling a function from a procedure within one schema which returns a column value from a table results in a return of the value from the table in a different schema! This happens continually but, as I say, not always.

First thought for me was the cache... these functions are called numerous times in rapid succession. Has anyone experienced a problem with a schema getting queries from cache which are the same semantically but which refer to a different schema?

Second thought was grants/permissions, etc... but this thought didn't really lead anywhere that I can think of.

The problem occurs whether or not you call the function in-line (within another query) or if you assign the function's return value to a local variable in a procedure.

I cannot find a reference to this type of occurrence on the Oracle site. If anyone else has seen this problem, I would appreciate knowing, and if anyone knows the solution.....!!

Thanks,
Sheila Thomas

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 16:34:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US