Alternative for dbms_output.put_line
April 16, 2007 4 Comments
The visitor statistics for a website/blog can be very revealing. And it’s interesting because it sort of turns the tables in that rather than a small handful of surfers finding my site as search engines react to what I’ve written based on what they are searching for, I can write an article based on those searches that the people who ended up at my site did.
Today I have had a significant number of hits for someone searching for ‘alternative for dbms_output.put_line’. Not sure why that search would lead someone to arrive at my site.
Depending on what you’re trying to achieve, another alternative is to write your messages to a table. My current method of choice is to write messages to table using an autonomous transactions that also sets session information using dbms_application_info. The sort of information is pl/sql module entry/exit points and other significant messages like session longops information (together with a maintenance proc and job to cleardown “old” messages).