error calling PackagesRSS

1 reply

Last post Feb 23, 2021 01:46 AM by samwu

‹ Previous Thread|Next Thread ›
  • error calling Packages

    Feb 22, 2021 07:08 PM|Manuel Rodriguez|LINK

    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

  • Re: error calling Packages

    Feb 23, 2021 01:46 AM|samwu|LINK

    Hi Manuel Rodriguez,

    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

    .NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
‹ Previous Thread|Next Thread ›