We’re running into a problem using ODBC to get data from Oracle. Specifically, using ODBC to access a stored procedure in a package.
Using ND7.0.1 and Oracle 8 or Oracle 9, we can successfully get back data using a stored procedure in a package.
Upgrading to Oracle 10, this same code fails with a cryptic “metadata” error message. Upgrading Notes to 7.0.3 (I saw something about a possibly related fix) gives us a different error message about fields not being defined.
I would troubleshoot the notes/code side more if this didn’t work on Oracle 8 and Oracle 9, but since it does I assume there is something about configuration of Oracle 10? Or a change Oracle made that isn’t yet reflected in Notes/Domino?
Note that if we take the store procedure out of the package and put it on the root then our code works with Oracle 8, 9, and 10. But they’re hesitant to go this route unless necessary. Likewise, they’re hesitant to only upgrade to Oracle 9 unless necessary.
Any helpful thoughts appreciated,
raphael