Menu

viewing error on package upload

Help
johan
2009-03-19
2013-04-15
  • johan

    johan - 2009-03-19

    Hello Toby,

    First of all, thanks for your work, it works even better than the Oracle official plugin.
    I only have two problem:
    - when I load a package to the database, it always say "The file has been succesfully compiled" but doesn't send it to the database.
    - when I select the whole code of my package, do Execute PLSQL, then it get's to the database, but doesn't display the errors.
    - "Refresh error status" always says "the file has no error"

    My file is called "online_services.bdy"

    Thanks a lot for helping.

     
    • Toby Zines

      Toby Zines - 2009-04-02

      Gday crazy,
      Thanks for your compliment :)

      As for your problems...
      I suspect the problem is that a .bdy is not being recognised as a loadable package, or the name of the file means that the schema it is getting loaded to is not the schema you want to look at.
      When you press the debug button (the target icon in the tool bar) what results do you get?
      Which schema do you want to load this to?

      My first recommendation is that you change the extension of the file to .pkg (if it is a header and body) and try to load it like that.

      If that works, the problem is the extension, which needs to be updated.
      Get back to me with any details regarding the load.

       
      • johan

        johan - 2009-04-06

        tobyz,

        Just tried, but it doesn't help.
        I send you the code by PM so you have something to test....

        BR.

         

Log in to post a comment.