JDeveloper Reports Unexpected Error from Database Adapater Wizard When Selecting Stored Procedure Whose Parameter List Includes Both REF CURSOR and User Defined Types
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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms