Re: Debuging in Stored-Procedures?

Christian,

It sounds like you want to use the dbms_pipes package.

I have written debugging pl/sql packages where the procedure to be debugged will send a message to a specified pipe, ie. "debug1" and listen for an answer on another pipe, ie. "listener1"

the debugger program will show information received from the pipe, and calls a procedure to send a message to "listener1" You only have to wait in the debugged package if you want to be able to break the package, or make it wait until you are ready to move on.

If I am to understand correctly the 2nd question. If you are running a very long procedure and wish to get pack periodic information about it's status, then pipes might serve you well there. the package will simply send a message about its status to a named pipe. A listener procedure will wait for messages sent to the pipe and do whatever you want with the status information.

Cris

Christian Hartmann wrote in message <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 - 23:38:12 CDT