DEBUG PL Code from FORM [message #648225] |
Thu, 18 February 2016 23:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a4c180f704a7112f0427460302842741?s=64&d=mm&r=g) |
pcouas
Messages: 112 Registered: February 2016
|
Senior Member |
|
|
Hi
i have page that calling an PL/SQL Code into an Package, when this procedure with 2000 lines failed, i ignore on which line. (i havent written proc with 2000 lines)
Could i debug line per line PL /SQL procedure when i use my form and obtain error line in PL/SQL ??
Regards
Phil
|
|
|
Re: DEBUG PL Code from FORM [message #648256 is a reply to message #648225] |
Fri, 19 February 2016 07:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/36d59a0945ac8359ba7f3b4ca41a7292?s=64&d=mm&r=g) |
geordibbk
Messages: 11 Registered: August 2015 Location: London
|
Junior Member |
|
|
Hi Phil,
I can see you are having some difficulty describing the problem but it sounds like you want to pass the error from PL/SQL into your APEX page?
In APEX when you are calling your PL/SQL package code, wrap it in a block with an exception handler like this and put the error into an APEX error stack so it shows on the page:
begin
package.procedurename;
exception when others then
apex_error.add_error (
p_message => apex_escape.html( 'Error : '||sqlerrm ||' at '||dbms_utility.format_error_backtrace),
p_display_location => apex_error.c_inline_in_notification
);
end;
Alternatively, you could log the error into a local table and debug like that.
[Updated on: Fri, 19 February 2016 10:11] Report message to a moderator
|
|
|