I have upgraded the version of MDAC on my machine from 2.5 to 2.6 and 2.7. But with both versions I keep getting 3 question marks returned from the output parameter of stored procedures that should return a string.
The version of oracle is 9i on the DB.

The parameter is of type adBSTR.

The provider that I'm using is MSDAORA.

I don't really want to use ODBC or the Oracle OLE DB provider as this would mean a lot of upheaval.

Has anybody got a reason/solution as to why this is happening?