Varchar input issue on function
Posted on 2013-10-25
I have a package which have 2 functions inside .
Function one returns a sys_refcursor and takes one input as varchar2
For example :
FUNCTION get_data_fnc(ip_uname IN varchar2) RETURN SYS_REFCURSOR;
Second Function takes the all the first function and another varchar as a input :
FUNCTION get_json_fnc(ip_rfc IN VARCHAR2
,ip_uname IN VARCHAR2) RETURN CLOB;
So finally when I call this should look as like below:
SELECT GET_JSON_FNC('GET_DATA_FNC('1627006644')','1627006644' )
But this doesn't work because of the input type as varchar2 to the inner function.
Can you please suggest me how to over come on this issue ....