I’m used to debugging packages, I can’t recall if I’ve ever tried it on standalone functions or procedures, but I assume it would work the same.
I see Burt’s post on TOADWorld about script debugging. Can it do anonymous blocks of PL/SQL or just sql*plus “scripts”.
I have anonymous block that we are running against our production database for a procedure not yet deployed into production, but we are doing production parallel testing before deployment. As such I have taken what will eventually be a standalone procedure in the database, commented out deletes and inserts and replaced them with dbms_outputs to show the results for comparison.
The procedure is having “issues”, I think it is falling into an infinite loop based on some data condition. Is there a way to debug this other than craploads of dbms_outputs? I’m aware of “auto debugging” and that would be better than nothing, but I’m not sure that would work if the process gets into a loop and we have to have the session killed. Wouldn’t I lose access to the dbms_output buffer?