Object in oracle giving as invalid (Invalid)

1

I gave select * from all_objects where object_name = 'meu_objeto'; . Well, that way, I had 4 lines. Two referring to SYNONYM and this does not interest me and two more lines: PACKAGE and PACKAGE BODY . In the (tuple) line referring to PACKAGE BODY , in the Status column, is INVALID . Must contain errors in code. How do I debug or see these errors in the package body? My object is a Package.

    
asked by anonymous 30.11.2015 / 16:30

1 answer

0

To debug a code in Oracle, both in package and in procedures, functions and etc, you need a program like PL / SQL or SQL Developer (which is free !!!!).

In them you can debug and test any of them, with debug and with interrupts and etc, as long as the user connected to the bank is with DEBUG CONNECT SESSION, a privilege of the authorized SYSTEM user, otherwise it will not authorize the debug

    
03.08.2016 / 20:47