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.
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