0 Replies Latest reply: Dec 8, 2011 5:50 AM by 702244 RSS

    how to get record set out with two parameter input as integer

    702244
      Hi All,

      i have a oracle function which is as follows

      Function email_list ( a_count in number, b_count in number ) return varchar2

      its return email list based on value ...

      return (peo_email_list);

      Now i have another procedure as below.... where i am calling my function

      Procedure sp_invoice_email_notification(p_nam_inv_count in number , p_latam_inv_count in number , p_email_list out refcursor);

      open p_email_list
      select email_list (1,0) from dual ;



      now in vbscript

      i am having

      With objCmd
      .ActiveConnection = objConn
      .CommandType = adCmdStoredProc
      .CommandText = "REMSI.pk_evs_interface.sp_invoice_email_notification"
      .Parameters.Append objCmdTrans.CreateParameter("p_nam_inv_count", adinteger, adParamInput, 20, snam_count)
      .Parameters.Append objCmdTrans.CreateParameter("p_latam_inv_count", adinteger, adParamInput, 20, slatam_count)
      .Execute
      Set objRs1= objCmd.Execute
      End With


      While not objRs1.eof


      speo_email = objRs1("peo_email")


      sTo=sTo&";"&speo_email




      objRs1.MoveNext
      wend



      here i am not getting any value .. and script is stuck .. please guide me how to get the function return value based on the parameter..

      regards
      shyam~