Re: Debuging in Stored-Procedures?

I don't know what the original question was but if you want to do some debugging,
then you may want to try SQL-Programmer from Sylvian Faust Intl. (SFI) http://www.sfi-software.com/

It's a very good development tool for Oracle, SQL Server and Sybase it includes sp debugging and many other features!

Hope it helps

--
------------------------------------------------
Rui Chambel
- Portugal -
Delphi, C++, VB, Java, SQL, I*net
e-mail: rchambel_at_netscape.net
------------------------------------------------
Make your life simple:
Write your own programs!
------------------------------------------------


Walter Dorninger <wdor_at_magnet.at> wrote in message
news:7rbo7a$onr$1_at_orudios.magnet.at...


> Well debugging ? - I don't think so that you can do all the stuff a

debuger


> offers with standard oracle tools.

> So I have two solutions for your problem:

>

> First Solution:

> But if you only want to log debug information you can use the

functionality


> in the optional "dbms_pipes" package to write log information to a

> client-application that connects to the pipe (oracle-pipe). You can also

use


> the "dbms_output" Package to log information in the current session (!!!)

> simply put "dbms_output.put_line ("WAYPOINT -1");" in your program and

start


> it and the text will be displayed in SQL*Plus

>

> Second Solution:

> Check out the tool TOAD (Tool for Oracle Application Developers). Is

really


> nice and you I think (I have never used debugging) you can do the

debugging


> stuff with it. You can download a trial version at

http://www.toadsoft.com/


> (its really worth to take a look at)

>

>

> For your second question i have 3 solutions ;-)

>

> (1) Just to implement FUNCTIONS in PL/SQL - you can simply return one

value


> e.g. an INTEGER or a BOOLEAN value with a FUNCTION

>

> (2) You can use OUT Parameters (just check out your PL/SQL Manual for OUT

> Parameters in combination with PL/SQL Procedures

>

> (3) You can raise an application error (user defined exception) and catch

> this error in your application - but don't use this for returning values

> etc. - thats not a good style to return calulation results ;-)

>

> If you have more questions - just tell me

>

> prost

> -Walter-

>

>

> Christian Hartmann <c.hartmann_at_tmp-office.de> wrote in message

> news:7rb85i$bdv$1_at_fu-berlin.de...

> > Hi there,

> >

> > we are using Oracle 7/8 Enterprise for Windows NT.

> >

> > First of all,

> > am I able to debug stored procedures (functions) by using a breakpoint

> after

> > starting the procedure

> > ?

> >

> > I want to transfer some of the client code to the database and I need

some


> > debuging, of course. I don't like the idea of checking 6-8 pages of code

> by

> > my eyes only.

> >

> > Secondly,

> > am I able to send a status back to the client, which started the

> > stored-procedure? I want to calc many things and I want the clients to

be


> > informed about the progress of the calculation. For example, can I send

a


> > status in a while-loop of a stored procedure back to the client?

> >

> > Any help will be appreciated.

> >

> > Thx,

> >

> > Christian Hartmann

> >

> >

> >

> >

>

>