Re: Debuging in Stored-Procedures?

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
>
>
>
>
Received on Fri Sep 10 1999 - 15:13:50 CDT