This discussion is archived
0 Replies Latest reply: Dec 8, 2011 3:50 AM by 702244 RSS

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

702244 Newbie
Currently Being Moderated
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~

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points