Team,

I have a weird problem. I'm working on an intranet web site ASP + Oracle
database.
I have to call a procedure named "REG_FIN" wich return 0 or many records.

Once i call my procedure via my ASP code i got this error:
"Error # 3704 Operation is not allowed when the object is closed"

But if i create the same procedure with a different name like "REG_FIN1"
and i change my call in asp code to: CmdFinADM.CommandText = "REG_FIN1" everything
work good and i get my result.
(Attention: "REG_FIN" and "REG_FIN1" both procedure must exists in the same
location at the same time)

- Note: I have created the same procedure "REG_FIN" in a seperate package,
and my all my call works good via "ASP Code".


Does anyone have a solution ??
Thank you in advance
Paul


Here's my Code:
----------------------------------------------------------
Dim RsFinADM
Set RsFinADM = Server.CreateObject("ADODB.Recordset")

Set CmdFinADM = Server.CreateObject("ADODB.Command")
Set CmdFinADM.ActiveConnection = Application("objConnection")

CmdFinADM.CommandText = "REG_FIN"
CmdFinADM.CommandType = adCmdStoredProc
CmdFinADM.Parameters.Append CmdFinADM.CreateParameter(, adVarChar, adParamInput,
12, pCode)

Set RsFinADM = CmdFinADM.Execute
While not RsFinADM.eof