to call a oracle stored procedure from classic ASP

[rk1_23]

hi all,
can anyone suggest me how to call a oracle stored procedure from asp.
i have a stored procedure with 2 i/p params and 4 o/p params
i just need to send 1 i/p param and get 1 o/p param frm it.
here im just validating my input field whether its valid( i mean just checking the status of my i/p field)
i tried using following code but its not working..if anyone has any code to call stored procedure..plz post it

Conn = Server.CreateObject("ADODB.Connection");
   Conn.Open ("Provider=MSDAORA;Data source=c_d;uid=abc;pwd=123;");

   Comm = Server.CreateObject("ADODB.Command");
   comm.ActiveConnection = conn
   comm.commandtype=4
   comm.commandtext = "cp_pkg.get_Appr"
   param = comm.createparameters
   comm.parameters.Append(comm.createparameter("p_id",200,1))
   comm.parameters.Append(comm.createparameter("p_em_status",200,2))
   comm("p_id") = "id"
   output = comm("p_em_status")
[\code]
 
error:  

Microsoft OLE DB Provider for Oracle[FONT=Times New Roman][/FONT][FONT=Arial][SIZE=2]error '80040e4d'[/SIZE][/FONT][FONT=Times New Roman][/FONT][FONT=Arial][SIZE=2]ORA-01017: invalid username/password; logon denied [/SIZE][/FONT]
 
 
when i login in toad with same userid /paswd it wrks fine
Suggest me what i need to do
 
Thanks in Advance
Riya