Urgent sys_ref cursor parameter in stored procedure

[nick_lovely]

New Message on dotNET User Group Hyd Urgent sys_ref cursor parameter in stored procedure Reply   Reply to Sender   Recommend Message 1 in Discussion From: nick_lovely I've a stored procedure with sys_refcursor out parameter.Can any one tell how to fetch data from _javascript_ file. I mean which parameter is to be added For example: Conn.addCharOutParameter("result",64000000); Code for stored procedure as follows:   PROCEDURE getXML                 (   tableName           in varchar2,                     PrjId               in varchar2,                     resultset           out sys_refcursor,                     errorCode           out number )     IS     query varchar2(256);       result    clob;       BEGIN     dbgMsg('Starting getXML...');     errorCode := 0;       query := 'select * from ' || tableName || ' where PrjId = ''' || PrjId || '''';       result := DBMS_XMLGEN.GETXML(query);       open resultset for     select result       from dual; end   Thanks, Mallesh View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.