0
I gave one select * from all_objects where object_name = 'meu_objeto';. Well, that way, I got four lines. Two lines referring to SYNONYM and that doesn’t interest me and two more lines: PACKAGE and PACKAGE BODY. On the line(tuple) referring to PACKAGE BODY, in the column Status, is INVALID. Should contain errors in the code. How do I debug or see these errors in the body of the package? My object is a Package.
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 interruptions and etc, since 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
Browser other questions tagged oracle pl-sql
You are not signed in. Login or sign up in order to post.
I was going to remove the post, but I decided to leave it to colleagues who fall into the same situation. I discovered the error. I was assigning within the
package, thus: my_var = new_value and when it should be: my_var := new_value. I forgot that in Oracle assign is::=– pnet
https://stackoverflow.com/questions/25247461/how-to-show-errors-in-sqlplus
– Motta