Java Help - PL/SQL Debugger Question

Author

PL/SQL Debugger Question

grasp06110

2006-05-30, 7:11 pm

Hi all,

Does anyone know of a good tool for debugging PL/SQL code? I know this
is not exactly the correct forum for this topic but I figure most of
you are like me and wear many hats and are likely to have had the
opportunity to work with PL/SQL.

Thanks,
John

IchBin

2006-05-30, 7:11 pm

grasp06110 wrote:
> Hi all,
>
> Does anyone know of a good tool for debugging PL/SQL code? I know this
> is not exactly the correct forum for this topic but I figure most of
> you are like me and wear many hats and are likely to have had the
> opportunity to work with PL/SQL.
>
> Thanks,
> John
>

I have not used this but with Oracle Database 10g and JDeveloper you can
Debugging a PL/SQL Package.

http://www.oracle.com/technology/ob...lsql.htm#debug1

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
________________________________________
__________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Rhino

2006-05-31, 4:13 am

"grasp06110" <grasp06110@yahoo.com> wrote in message
news:1149023401.302318.107580@u72g2000cwu.googlegroups.com...
> Hi all,
>
> Does anyone know of a good tool for debugging PL/SQL code? I know this
> is not exactly the correct forum for this topic but I figure most of
> you are like me and wear many hats and are likely to have had the
> opportunity to work with PL/SQL.
>
First, don't multipost. If you don't know which newsgroup to use, crosspost
so that people know you have already posted to other newsgroups and can see
those answers as well.

Second, there are different dialects of PL/SQL and I'd be surprised if they
can all be debugged with the exact same tools. I've written PL/SQL for DB2
and I know that Oracle - and probably other databases as well - have
different dialects of PL/SQL. You have already been told about a tool that
will debug Oracle PL/SQL. I know that DB2 has its own debugger for its
version of PL/SQL and it comes free as a basic and integral part of DB2.

If you are using some other dialect of PL/SQL, look into the Help files that
come with the database you are using or post to a newsgroup that specializes
in that database and you'll probably find a tool that will let you debug
your PL/SQL procedures.

--
Rhino

Mark Haase

2006-05-31, 4:13 am

In article <y_WdnR9FFo5ne-HZUSdV9g@ptd.net>, IchBin <weconsul@ptd.net>
wrote:

> grasp06110 wrote:
>
> I have not used this but with Oracle Database 10g and JDeveloper you can
> Debugging a PL/SQL Package.
>

PL/SQL Developer is the best

--
|\/| /| |2 |<
mehaase(at)gmail(dot)com

steve

2006-05-31, 8:13 am

On Wed, 31 May 2006 07:20:46 +0800, grasp06110 wrote
(in article <1149023401.302318.107580@u72g2000cwu.googlegroups.com> ):

> Hi all,
>
> Does anyone know of a good tool for debugging PL/SQL code? I know this
> is not exactly the correct forum for this topic but I figure most of
> you are like me and wear many hats and are likely to have had the
> opportunity to work with PL/SQL.
>
> Thanks,
> John
>

go for
http://www.allroundautomations.nl/index.html

pl/sql developer.

Jdeveloper is ccccccccrrrrraaaappp, for debugging pl/SQL and for writing
it.

just try changing values or displaying tables as you are running.

I.E
a table that contains a nested table, breaks jdeveloper
a table that contains a BLOB/CLOB breaks jdev if you try to edit another
value in the same row.

allroundautomations will even allow you do de-nest & view a table within a
table within a table.

and it has a 30 day evaluation.

Steve

Sponsored Links