Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help:How to get debug message from procedure into C++ prog

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

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Tue, 11 Jan 2000 16:30:45 +0100
Message-ID: <387B4CA4.30A7DDA8@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. Sorry
Another way is to create a table and insert the debuggung information in your pl-sql package into this
table.
create table debugoutput ( message varchar2(256), datetime date); in PL-SQL Procedure
.......

insert into debugoutput ("Line 1",sysdate);

...
...
...

insert into debugoutput "Line XXX",sysdate).

and so on.

Dirk his Linux bakje wrote:

> Hi
>
> I have a problem, can someone give me more information.
> I have declared a stored procedure which calls several other procedures.
>
> When I execute the procedure outof PL/SQL everything works properly. But
> when
> I call the same procedure outof a C++ programm the procedure doesn't
> work.
> Does some know this problem?
> How can I generate message in the procedure and so I can debug the
> procedure in C++.
> Thanks whith best regards
> Dirk Joosen
> d.joosen_at_planetinternet.nl

--



ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
Received on Tue Jan 11 2000 - 09:30:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US