Open Dharma1986 opened 9 years ago
What about returning a refcursor and a normal variable like a long?
procedure ibp_countrystate_getlist
(
p_country_id in number,
SOME_ID OUT LONG,
p_cntry_getlist out SYS_REFCURSOR,
p_state_getlist out SYS_REFCURSOR
)
Hi Good day!
I can able to import function for stored procedure of oracle db and able to add the complex type and get the output but i tried to import the procedure which having two ref cursors and unable to retrieve the column information. Only able to retrieve the columns of first ref cursor. Please help me to get the result of two ref cursors which acting as out parameters.
below is the my oracle db sp
and my web.config for refursor configuration is below..