Urgent Help Please - 3704 Operation is not allowed when the object is closed

[Paul]

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

[Q*bert]

Sounds like a recordset object which your using is being closed early.

check to make sure that your not closing the rs object before you've gotten
everything out of it. (consider creating a new rs object (differnet name)
as a test for this from that function.)

"Paul" <paulnamroud@hotmail.com> wrote:
>
>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

[piter]

HI ALL !!
I am facing same problem. Actually its in VB. i developed a Package. While
working on that package everything goes well. but while shutting-down the
system automatically error appears.
"Error # 3704 Operation is not allowed when the object is closed"
Please reply.
Piter



"Q*bert" <luke_davis_76@hotmail.com> wrote:
>
>Sounds like a recordset object which your using is being closed early.
>
>check to make sure that your not closing the rs object before you've gotten
>everything out of it. (consider creating a new rs object (differnet name)
>as a test for this from that function.)
>
>"Paul" <paulnamroud@hotmail.com> wrote:
>>
>>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
>