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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center