Expand my Community achievements bar.

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

Avatar

Level 1
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
0 Replies