vbscript not retrieving values from a working PL SQL stored procedure

[EDN Admin]

p.p1 {margin: 0.0px 0.0px 12.0px 0.0px; font: 13.0px Arial} span.s1 {color: #f61710}
Please point me the correct forum if this is not it. I couldnt find the vbscript one that you used to have.
Im struggling with a vbscript trying to retrieve a value from a PL SQL stored procedure.<br/>
Ive successfully confirmed connection by trying a simple select query to the database and it works.<br/>
Ive also successfully confirmed that the stored procedure Im using has been granted rights to execute using the account that I am logging in with.
The error that I am getting is ORA-0143: no data found
Here is how Im setting this up.

Set comhrmswr = Server.CreateObject("ADODB.Command")<br/>
Set comhrmswr.ActiveConnection = cnhrmswr<br/>
comhrmswr<span> . commandtype = adCmdStoredProc<br/>
comhrmswr.commandtext = "MY_STORED_PROCEDURE"<br/>
<br/>
strLANID2 = "MYLANID" <br/>
comhrmswr.Parameters.Append comhrmswr.CreateParameter("@s_LANID", adVarChar, adParamInput, 100, strLANID2)<br/>
comhrmswr.Parameters.Append comhrmswr.CreateParameter("@v_g_role", adVarChar, adParamOutput, 100)<br/>
comhrmswr.Parameters.Append comhrmswr.CreateParameter("@v_sup_email", adVarChar, adParamOutput, 100)<br/>
comhrmswr.Parameters.Append comhrmswr.CreateParameter("@v_sup_g_role_role", adVarChar, adParamOutput, 100)<br/>
<br/>
comhrmswr.Execute()
Thank you in advance for any tips or suggestions

View the full article