I am having issues when executing a Oracle stored procedure via the JDBC adapter.
I have configured a JDBC adapter to connect to our Oracle QA instance from my WM DEV instance. When I create the adapter service (in DEV) I can select current catalog, and see a list of schemas on this database. Choose the right procedure and everthing works fine within DEV environment.
When I promote this adapter service to my QA environment is when I start having problems. If I try to edit the same adapter service created in DEV I can no longer choose a schema name and it remains blank. When this executes it executes as “call ..” which of couse fails because it cannot find the procedure. When executed from DEV it executes as "call .. and runs without errors.
If I try to create a new adapter service on my QA environment using the same JDBC connector I receive an error about not being able to retrieve a list of schemas. Is this something I can correct within the JDBC connector or is this a Oracle issue?
I have tried using 2 different user accounts, schema account and another user granted access to procedure. I am using WM 8.2.