Skip to Main Content

Error when Web Service invoke complex object to DB

MarinzMay 3 2019 — edited May 6 2019

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:

  • FUNCTION f_importa_RM

      ( 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?

Post Details
Added on May 3 2019