0 Replies Latest reply on Oct 19, 2007 12:49 PM by mh10

    How to call c# webservice in Flex which then calls oracle stored procedure

    mh10
      Hi all,

      I am calling c# webservice having webmethod which then calls one Oracle stored procedure. This Oracle stored procedure returns ref cursor i.e multiple row output.

      Webservice webmethod is 'getEmpData' has two input variables v_city, v_state.
      [WebMethod]
      public DataSet GetEmpData(string v_city, string v_state)
      {

      This webmethod then calls 'Emp_data' oracle stored procedure which takes these two input parameters and returns Ref cursor.

      How can i retrieve this oracle Ref cursor data in Flex using webservice component?

      Thank you