ODBC PL/SQL tracing questions

Hello,

I just have a couple of questions about tracing in PL/SQL and ODBC and the effects on performance.

Firstly, I have an app in C++ that calls some stored procedures using ODBC API. However,I need to trace errors/data/diagnostics information etc etc. My question is how efficient is it to use the DBMS_OUTPUT.put_line function? I have been told that it will slow the Database down significantly when there is a lot of traffic. If it is slow, is there a better (more efficiant) way to trace problems (i.e. another package)? Importantly, the software will be used 24 hours a day with varying amounts of traffic.

I also have the other option of passing back the error information from the stored procedure via ODBC to the C++ program and log it there - also meaning that only 1 log file is used ( and the errors are sychronised with the flow of control in the C++ program ). Has anyone any ideas on which option would be the best taking into consideration performance and efficiency.

Thanks,

Andy Shiels

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 09 1999 - 03:45:25 CDT