When debugging a procedure using DBMS Debugger option, Toad hangs on step raise_application_error. Backend process shows that it is stuck on this line.
DECLARE
ret BINARY_INTEGER;
BEGIN
ret := pbsde.debug_loop;
END;
Below is a sample procedure:
CREATE OR REPLACE procedure ISA_BREEDING.aaa is
v varchar2(2);
begin
dbms_output.put_line('sdhfhd');
v:= 'aaaa';
exception
when others then
raise_application_error( (-20000-224) - 55, <------
SUBSTR(SQLERRM,1,200));
end;
The error happens when connecting to Oracle 11g.
Software bug
WORKAROUND:
Use JDWP Debugger instead of DBMS when debugging PL/SQL with raise_application_error.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
