Re: Help:How to get debug message from procedure into C++ prog

Andreas Michler <Andreas.Michler_at_adicom.de> wrote in message news:387B4CA4.30A7DDA8_at_adicom.de...

> I suppose you're debugging with dbms_out.put_line in your pl-sql
procedures
> and you switch it
> on via "set serveroutput on".
> In this case there is no way (I know) you can't see it in your C-program.

Why not, it's easy. You could read dbms_output messages from Your client application by calling dbms_output.get_line (or dbms_output.get_lines). Dont forget to call dbms_output.enable.

> Sorry
> Another way is to create a table and insert the debuggung information in
> your pl-sql package into this
> table.

Hm, of course it works, but You'll have a lot of problems if You transaction would be rolled back.

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua) Received on Tue Jan 11 2000 - 10:09:11 CST