Calling PL/SQL procedure in ASP--NEED HELP URGENT

[mmcg]

Hi
I am having a problem in opening the recordset as a result of the following ASP code calling an ORACLE procedure
Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.open "DSN=****;UID=####;PWD=&&&&"
Set Comm = Server.CreateObject("ADODB.Command&quot
Set comm.ActiveConnection = conn
set rs=Server.CreateObject("ADODB.recordset&quot
comm.commandtype=4
comm.commandtext = "test"
Set rs = comm.execute()
response.write rs.eof

The oracle procedure is as

Create or replace procedure test as
a varchar2(10);
begin
select ename into a from emp where emno=7844;
dbms_output.put_line ('The employee is'||a);
end;

I get the following error:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/aspproc.asp, line 21


Line 21 is: response.write rs.eof


I appreciate any help
Thanking you in advance
MMCG