4 Replies Latest reply on Jun 15, 2011 10:14 AM by 867801

    Invoke DBAdapter from BPEL for a proc with SYS_REFCURSOR as IN parameter

    867801
      I have a procedure with inputs as 2 sys_refcursor and 1 output as string as below:

      Total IN Number,
      PType IN SYS_REFCURSOR,
      PEType IN SYS_REFCURSOR,
      IsSuccess OUT VARCHAR2

      Here PEType is a sub node of PType.


      When I create a DBAdapter in BPEL it’s throwing the below error and the adapter is not getting created:

      BINDING.JCA-11824
      Input ResultSet not permitted.
      ResultSets are not permitted as input to an API.
      Encountered an input ResultSet at parameter PROMOTIONTYPE in the API.
      ResultSets can only be retrieved as output from an API. Remove any input ResultSets from the API.

      Any help/pointers to resolve this would be highly useful.