Call to sp on linked schema fails when using PLSQLRSet=1 with Oracle 11

Hello,

we have migrate a database with mutliple schema from Oracle 10 to Oracle 11.

We have existing VB6 applications using OraOLEDB to communicate with the database.

The connection string looks like this

Provider=OraOLEDB.Oracle;Password=DurchPasswortZuErsetzten;User ID=DurchBenutzerZuErsetzten;Data Source=Schema;Extended Properties='PLSQLRSet=1; DistribTx=0;fetchsize=-1'

Which works fine with Oracle 10.

Using Oracle 11 throws the following exception:

ORA-06550: Zeile 1, Spalte 14:
PLS-00302: Komponente 'xyz' muss deklariert werden (Componenten 'xyz' must be declared)
ORA-06550: Zeile 1, Spalte 7:
PL/SQL: Statement ignored

 

'xyz' is the name of the linked database schema. Therefore I am unable to call the stored procedure.

When I set PLSQLRSet to 0 the stored procedure is found, but because the first output parameter is a RefCursor which cannot be defined using ADO the call fails