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:
Oracle JDeveloper - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |