2 Replies Latest reply: Jan 15, 2014 9:58 PM by Aasubram-Oracle RSS

    Debugging in SQLDeveloper

    Aasubram-Oracle

      Hi,

      Is the following situation attainable through SQLDeveloper?

       

      i.e To debug a database function which is in a package. The debugging user is not the owner of the package

       

      For example

       

      - grant debug connect session to user1;

      - grant debug any procedure to user1;

      - grant debug connect session to user2;

      - grant debug any procedure to user2;

      - User1 has a package pk1 and a function f2

      - package pk1 has a function f1

      - User1 grant execute on package pk1 to user2

      - User1 grant execute on function f2 to user2

      - User2 has a synonym f2 for user1.f2

      - User2 has a synonym pk1for user1.pk1

      - in user1 : alter package pk1 compile debug

      - in user1 : alter function f2 compile debug

      - When I try to debug pk1.f1 via Oracle Forms while connected to user2 I can't see pk1.f1'code

      - When I try to debug F2 via Oracle Forms while connected to user2 I can see f2'code

       

      It seems that in Forms: it is possible to debug a database function, but impossible to debug a database function which is in a package.

       

      Is there a problem to debug a database function which is in a package via SQLDeveloper (when the oracle user is not the owner of the package)?

       

      Thanks,

      Anand