Re: Need Help with some PLSQL code please

bsc7080mqc_at_mylxhqremoveme.com wrote:

>Just my two cents worth...
>
>I think the comments from others would be that in most instances, the
>end user would never see the serveroutput. If you are using Oracle
>applications, consider using the FND_FILE.PUT which will let you write
>to the OUTPUT file or LOG file of the concurrent manager job.
>
>If you are not using Oracle Applications, try writing to a custom
>global Audit Log table, using process_id and sub_process_id's to
>identify jobs and their steps. Then you can wrap a form or web page
>around the log table or even a report.
>
>On Sun, 14 Sep 2003 16:52:33 +1000, "Chris \( Val \)"
><chrisval_at_bigpond.com.au> wrote:
>
>

What are you talking about?

SQL> select object_name from dba_objects   2 where object_name like 'FND%';

no rows selected

SQL> If you want to write to a file use UTL_FILE. If you want to write a report get Oracle Reports, Discoverer, Seagate (Crystal), Cognos or Brio.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)