I am getting the following error when I try and execute an Oracle stored procedure from an ASP page using ADO:<BR><BR><BR>ADODB.Command error &#039;800a0bb9&#039; <BR>Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR>test.htm, line 254 <BR><BR>Line 254, refers to the following line in my ASP code:<BR><BR>Set objParam = .CreateParameter("i_querystring", adBSTR, adParamInput, , strq)<BR><BR><BR>Now, if I try and execute the code without using a parameter, I have no problems, so I know <BR>that I am doing something wrong when issuing a parameter. Any help would be greatly appreciated.<BR><BR>Below is my SP and ASP code.<BR><BR><BR>********************************* ***************************<BR>CREATE OR REPLACE PACKAGE HR_Pkg<BR>AS<BR><BR>TYPE mycursor IS REF CURSOR;<BR>PROCEDURE GetJobs(i_querystring IN varchar2,<BR> o_recordset OUT mycursor);<BR><BR><BR>END HR_Pkg;<BR><BR>*********************************** **************************<BR><BR>CREATE OR REPLACE PACKAGE BODY HR_Pkg<BR>AS<BR><BR><BR> PROCEDURE GetJobs(i_querystring IN varchar2,<BR> o_recordset OUT mycursor)<BR> IS<BR> BEGIN<BR> OPEN o_recordset FOR<BR><BR> <BR> SELECT<BR> job_name,<BR> title<BR> FROM tbl_s<BR> WHERE subject = &#039;i_querystring&#039;;<BR><BR> <BR> END GetJobs;<BR><BR>END HR_Pkg;<BR><BR>*********************************** **************************<BR>&#060;%<BR> strq = "Jobs"<BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=web;User ID=me;Password=me;PLSQLRSet=1"<BR> objConn.Open<BR> set cmd = server.CreateObject("ADODB.Command")<BR> With cmd <BR> Set .ActiveConnection = objConn<BR> .CommandText = "{call HR_Pkg.GetJobs(?)}" <BR><BR> Set objParam = .CreateParameter("i_querystring", adBSTR, adParamInput, , strq)<BR> .Parameters.Append objParam<BR><BR> Set objRS = .Execute() <BR> End With <BR><BR> Do While Not objRS.EOF<BR> response.write objRS.Fields("job_name") & "&#060;br/&#062;"<BR> objRS.MoveNext<BR> Loop<BR>%&#062;