Hi there,
The DBA's have just upgraded the Oracle listener on my Dev & Test box. I have a number of CR's that are connected to Stored Procs on either of these servers.
Now, these CR's work just fine. I can modify the stored procs & verify the DB in the CR, all with no problems.
However, if I try to connect a new CR to the same stored proc, I get an Oracle error ORA-01001, which basically says, the Cursor you are trying to access is closed.
Before the listeners were upgraded, I had no problems at all.
Has any one else experienced this problem? If so, any suggestions on how you got around it?
Hoping some one can help,
Peter.
The DBA's have just upgraded the Oracle listener on my Dev & Test box. I have a number of CR's that are connected to Stored Procs on either of these servers.
Now, these CR's work just fine. I can modify the stored procs & verify the DB in the CR, all with no problems.
However, if I try to connect a new CR to the same stored proc, I get an Oracle error ORA-01001, which basically says, the Cursor you are trying to access is closed.
Before the listeners were upgraded, I had no problems at all.
Has any one else experienced this problem? If so, any suggestions on how you got around it?
Hoping some one can help,
Peter.