Posted By: usertale DBMS_OUTPUT cause debugger to hang. - 03/19/08 07:37 AM
BEGIN
DBMS_OUTPUT.ENABLE(1000000);
DBMS_OUTPUT.PUT_LINE(Program started at ' || TO_CHAR(SYSDATE, 'DD-MON-YY HH:MI:SS'));

run_proc(1);
END;
/

The above code in a test script causes the debugger to hang, waiting on an (internal) PIPE call.

Is this a bug??
Posted By: Marco Kalter Re: DBMS_OUTPUT cause debugger to hang. - 03/19/08 03:25 PM
You could try the following:

1. Increase the shared pool size.

The Oracle Debugger seems to have some stability issues when there is not enough free memory in the shared pool.

2. Disable the call stack.

Go to Tools > Preferences > Debugger and disable the "Update call stack after each step".

3. Check for user trace files on the server.

It may be that the server process has died. Check if a trace file exist that is related to the problem, and if so, send it to me.
© Allround Automations forums