2 Replies Latest reply on Oct 30, 2015 2:59 PM by Earl Lewis

    Debug/run procedures within package

    Earl Lewis

      Debugging in SQL Developer has generally been very nice and I have come to depend on those tools. Today I wrote a procedure within a package and I want to debug that procedure, but I don't see it in the list of targets. It seems that i'm only seeing functions in the target list. I understand that procedures don't have the same kind of output as functions, but occasionally I like to create procedures that have multiple OUT parameters, especially when it's a very closely related output.

       

      The interesting thing is that I can create this very same procedure as a standalone procedure and the run/debug works just fine. Apparently I'm missing something obvious in SQL Developer somewhere. I thought this was there a while ago (I guess it's been a little while since I wrote a procedure with OUT parameters) but maybe I'm mistaken. Any ideas or help anyone?

       

      Earl