Re: Debuging in Stored-Procedures?

Christian,

Yeah...I do my debugging in procedure builder (part of developer). It allows for breakpoints and the like. (I also use this product to create and manage database triggers).

Also, I had a similar need for handling messaging from stored proc to client. I had a table that was updated when the stored proc started and in the actual stored proc, I had statements that updated that table. Then the client had a 'check on proc' button. It listed all the active stored procedures (that were running), and they could click on the one that they wanted (stored proc name, description, user who started and date/time) and it would give them the most current status. I did it this way, but there are probablly other ways.

HTH... scott felten
sfelten_at_pilot.infi.net

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 Mon Sep 13 1999 - 09:03:01 CDT