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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

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

  1. #1
    Paul Guest

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


    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

  2. #2
    Q*bert Guest

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


    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



  3. #3
    piter Guest

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


    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

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center