Last updated on JANUARY 04, 2011
Applies to:Oracle SOA Platform - Version: 126.96.36.199.0
Information in this document applies to any platform.
At design time, when using JDeveloper to define an instance of the Database Adapter based on the stored procedure, you encounter an error at "Step 5 of 7: Specify Stored Procedure" of the Database Adapter wizard. When you reach that stage, where you use the "Browse..." option to identify and select stored procedures defined in a procedure, then after selecting the desired procedure in a pop-up window you encounter the following error when returning to the database adapter wizard:
An error occurred while retrieving stored procedures.
Verify that the Database Connection is valid.
The issue does not reproduce when the target database is an Oracle 11g Database Server, only when the target is an XE, 10.2 or 9.2 version of the Database Server product.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms