How to Update an Oracle Stored Procedure with ADO and ASP

From: Mr Not So Know It All (djscratchnsniffing_at_yahoo.com)
Date: 03/23/05 

Date: 23 Mar 2005 06:50:48 -0800

I've been trying to use an update stored procedure via ASP and ADO. The
SP works when I use Oracle SQL Plus. Thus, I think the procedure is ok.
When I try to execute it from my ASP page, I get the following error.

Provider error '80040e55'

Column does not exist.

Here is the ASP code

qSQL = "{call update_employee(?)}"
        with objComm
          .activeconnection = objConn
          .commandtext = qSQL
          .commandtype = 1 'adCmdText
    end with

objComm.Parameters.Append
objComm.CreateParameter("p_employee_ID",adInteger,adParamInput,50,eID)

    'set recordset to objcommand execute
    Set Rs = objComm.Execute

Here is the stored procedure:

CREATE OR REPLACE PROCEDURE "HR"."UPDATE_EMPLOYEE" (
 p_employee_ID in employees.employee_id%type
)
as
begin
 update employees set last_name = 'Jones' where employee_ID =
p_employee_ID;
end;

can please someone help?