Confusing schemas on running SP

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yevgeny
Posts: 15
Joined: Sun 11 Sep 2005 16:51
Location: Israel
Contact:

Confusing schemas on running SP

Post by yevgeny » Thu 07 Feb 2008 21:38

Hello,

I am working with Oracle 10.2.0.3.0 and Delphi 7.
ODAC version: 5.80.0.41 Net.

We are working with a database containing multiple identical or similar schemas (only data is different). Our application chooses on startup a specific schema to work with.
During last couple of days we experienced a situation when a specific stored procedure was taken from another schema, not the schema we connected to. A couple of hours ago the problem disappeared by itself without any obvious action has been taken.

We encountered such a problem last summer and then also the problem disappeared by itself.
The common between two procedures is that they have both regular and cursor OUT parameters, but we have many such procedures. Don't think it is relevant.

Have you heard about this problem and do you have any idea how to solve it?

Thanks,
Yevgeny

Post Reply