Jdeveloper12C Does Not Include Functions which Reference types/records Defined in another Package. (Doc ID 2919052.1)

Last updated on JANUARY 10, 2023

Applies to:

Symptoms

JDeveloper 12.2.1.4 does not include functions, which reference types/records defined in 'another package', when generating SOAP Web Service based on PL/SQL Package. The following steps shows the wizard is not able to select the second function that references a type defined in another package: 

1. Create two packages in HR schema in your database where package1 will define a type and package2 will reference that type.
2. Open JDeveloper 12.2.1.4
3. Create a Database Application: File --> New Application --> Database Application
4. Create a SOAP Web Service Project: File --> New --> Project --> SOAP Web Service Project.   
5. Right click on WebService project --> New --> From Gallery --> TopLink DB Web Service Provider
6. In the wizard, click on Next --> Generate PL/SQL Web Service Provider, then click Next.
7. Create a database connection to HR schema to access package2
8. Once connected, you will see the Database package, click to drop down to select package2
9. SOAP Version: SOAP1.1
10. Click Next. Now you should see function2 which references a type defined in package1 is grayed out. 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.