2 Replies Latest reply on Apr 1, 2016 3:03 AM by G Vijay

    How to generate REST webservice Using Jdeveloper12c for a PL/SQL Object

    G Vijay

      Hi All,

       

      I want to generate a Web service for a PL/SQL package using JDeveloper12c. I tried the link Working with PL/SQL Web Service in JDeveloper 12c

       

      But it seems Jdeveloper has limitations to generate the Webservice for a PL/SQL package.procedure which has DB Object types (Type and table type ) as in/out parameters. Ex..

       

      create or replace type xx_db_type as object (org_id NUMBER);

       

      CREATE OR REPLACE TYPE XX_SYNC_ORG_TBL AS TABLE OF xx_db_type;

       

      create or replace type xx_db_type2 as object (column_1 NUMBER, column_2 NUMBER);

       

      CREATE OR REPLACE TYPE XX_SYNC_ORG_TBL2 AS TABLE OF xx_db_type2;

       

      now the procedure in the package is been defined as below

       

      Procedure xx_sync_proc (p_XX_SYNC_ORG_TBL IN XX_SYNC_ORG_TBL,p_XX_SYNC_ORG_TBL2 OUT XX_SYNC_ORG_TBL2 )

      is

      BEGIN

      NULL;

      END;

       

      Now when i tried to generate the webservice for the above package.procedure structure the in the select program unit window (JDeveloper) the procedure lists out but it is gray out and dont allow me to select the same..

       

      Can anybode let me know how i can proceed in this case.

       

      Thanks in advance...

       

       

      -Vijay G