Confusing schemas on running SP
Posted: 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
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