| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help:How to get debug message from procedure into C++ prog
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);
... ... ...
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
--
 |
 |