Re: How to debug packages?

2 ways I try to debug packages:

1. If I don't use any PL/SQL 2.0 features that are not in 1.1, I put it in a set of functions etc in Forms 4.0 and do 'synchronize' updates to the screen so that I can see the values of variables at any given time.
2. I have a table in my own space called junk consisting of a junk_id (sequence number), text (varchar2(1000)), and date. I also include a before insert trigger to input the sequence number when an insert occurs. Finally, I have a stored procedure called 'shove_it' (seems appropriate to me!) that takes a varchar2 as an argument and stores it in my junk table. I can then quickly slip 'shove_it' calls into my packages and use selects when done to see what was happening when things went south. I found this much better than the "output" suggested by oracle.