Re: Application Express - debugging

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 18 May 2007 10:17:00 +0200
Message-ID: <f2jncv$sk4$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Manny schreef:
> On May 17, 2:32 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
> Manny schreef:
>

>>>> Hi, newbie question here.
>>>> I want to know if there is a debugger (besides debug messages) that
>>>> can be used to debug Application Express projects.  Hopefully there is
>>>> some kind of Forms debugger for this product.  So if anyone knows of
>>>> anything out there....maybe a third party product?  Please post to
>>>> this thread.
>>>> Thanks
>>>> Manny

> There's one in APEX itself... Shows all the calls made, and
> the time spent in each call.
>
> If that's not what you're looking for, (commercial) products
> for PL/SQL development usually have a debugger:
>
> TOAD (by Quest, very $$$), PLSQL Developer (by Allround Automation,
> Better debugger than TOAD) and SQL Developer (by Oracle, free)
> are three examples. JDeveloper also has a surprisingly good
> PL/SQL debugger (surprisingly, as it is a Java development tool)
> TOra probably has a debugger, too, but I have not seen any recent
> version of it, and have never used it in a previous one. TOra was
> launched as the free once more verion of TOAD, when TOAD went
> commercial. It runs on Linux.
>
> If that is not enough, post clear requirements

> Thanks Frank,

> However, I was not looking for just a simple PLSQL debugger since Toad
> can do that. However, in Oracle Formsbuilder there is a very good
> debugger that allows one to set break points in the code and step
> through the execution of the application one line at a time and also
> see the block variables and set Watch variables as well. I was
> wondering if there is something like that for Oracle Application
> Express?

> Manny

TOAD, PLSQL Developer, SQL Developer and JDeveloper can all do breakpoints, watches, executes until, display variable values and probably a lot more.
Looks like you have TOAD - look at the Debug submenu (activation of the menu may depend on your license).

The problem I see, it you will have to (re-)compile in debug mode, and a lot of the ApEx stuff is wrapped, so Oracle won't let you do that.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGTWD8Lw8L4IAs830RAusEAJ9uUM5d/57tUyXPSX0Qn2C7NXqZGACfWPCE DlqJHiLgH/uk9ocM4LsF+6s=
=GO5D
-----END PGP SIGNATURE----- Received on Fri May 18 2007 - 03:17:00 CDT