locked
error calling Packages RRS feed

  • Question

  • User1846593803 posted

    Hello good afternoon to everyone

    I like to be a consultant:

    I have an ASP page that works perfectly with an oracle procedure, in that there is nothing to do, it works perfectly.

    My problem is when I change the procedure for a pkgs ... when calling the call does not work .. then I leave my code

    this code is perfect

    sub sp_crea_callCenter(nombre)
        Set execu = Nothing
        Set execu = Server.CreateObject(dllName + ".Execute")
        execu.AddPar nombre
        execu.ExecuteSP "sp_crea_callCenter"
    end sub

    nCallCenter             = Request("txtNomCallCenter")

    call sp_crea_callCenter(nCallCenter)
    nError = execu.CodError

    but when I call the PKGS it no longer works, the error says that it does not know the object.

    sub pkgs_callcenter.sp_crea_callCenter(nombre)
        Set execu = Nothing
        Set execu = Server.CreateObject(dllName + ".Execute")
        execu.AddPar nombre
        execu.ExecuteSP "pkgs_callcenter.sp_crea_callCenter"
    end sub

    nCallCenter             = Request("txtNomCallCenter")

    call pkgs_callcenter.sp_crea_callCenter(nCallCenter)
    nError = execu.CodError

    Monday, February 22, 2021 7:08 PM

All replies

  • User1065476709 posted

    Hi Manuel Rodriguez,

    sub pkgs_callcenter.sp_crea_callCenter(nombre)
        Set execu = Nothing
        Set execu = Server.CreateObject(dllName + ".Execute")
        execu.AddPar nombre
        execu.ExecuteSP "pkgs_callcenter.sp_crea_callCenter"
    end sub

    nCallCenter             = Request("txtNomCallCenter")

    call pkgs_callcenter.sp_crea_callCenter(nCallCenter)
    nError = execu.CodError

    I suggest you set breakpoints to debug your code to see where the problem is.

    And this is the iis forum, your question is related to vb. I suggest you go to the asp.net forum or Q&A forum for help.

    https://forums.asp.net/

    https://docs.microsoft.com/en-us/answers/index.html

    Best regards,

    Sam

    Tuesday, February 23, 2021 1:46 AM