I have a problem when invoke a Web Service create from Package PL/SQL
In DB there are Complex structures created in this mode:
- create or replace TYPE "TBL_FIRST" AS TABLE OF rec_first
- create or replace TYPE rec_first
AS OBJECT ( Id NUMBER,
String1 VARCHAR2(20 BYTE),
String2 VARCHAR2(40 BYTE),
String3 VARCHAR2(20 BYTE),
Integer1 NUMBER(10),
Second_List TBL_SECOND
)
- create or replace TYPE "TBL_SECOND" AS TABLE OF rec_second
- create or replace TYPE rec_second
AS OBJECT ( String4 VARCHAR2(10),
BigDecimal1 NUMBER(12,3),
BigDecimal2 NUMBER(12,3),
BigDecimal3 NUMBER(12,3),
BigDecimal4 NUMBER(12,3),
BigDecimal5 NUMBER(12,3),
BigDecimal6 NUMBER(12,3),
String5 VARCHAR2(3)
)
The function called from WSDL is:
( p_ID_TRANSAZIONE IN VARCHAR2
, p_TIMESTAMP IN TIMESTAMP
, Lista_Registrazioni IN TBL_RM_HEADER
)
I have created with Jdeveloper 12c (Toplink) a Web Service and XSD is created correctly
BUT in SOAPUI, when I call the WS,I have this error:
<env:Text xml:lang="en-US">fImportaRm failed: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "XXX.REC_SECOND"
Error Code: 17060
Does anyone have suggestions?