I was not able to find any information about Merant DataDirect ODBC driver version 4.20 support for Oracle 10g Rel 2 database. Can someone help? My problem:
We are trying to get a list of stored procedures in Oracle 10g DB by using above mentioned ODBC driver connection. However, listing against database does not return any of the users schema stored procedures including procedures in packages. Is this limitation that comes with the 4.20 driver or does user have insufficient privileges? If listing is done against Oracle 9i database, everything works ok. The 9i database user has same privileges compared to the user in 10g database. I have also tried to give DBA rights to 10g which should result to see all schema objects in the database. This won't help either.