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?