Re: Need Help with some PLSQL code please

If you can't find it... its because you aren't using Oracle Applications... just the database. My previous job, we didn't use Oracle Apps, so I implemented the latter suggestion.

UTL_FILE doesn't help much if you want to be able to report and do analysis. It ultimately depends on what you want to do.

On Sun, 14 Sep 2003 20:39:46 -0700, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>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.

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com
bsc7080mqc_at_mylxhp.com
(replace mylxhp with mylxhq to reply/contact) Received on Mon Sep 15 2003 - 05:36:50 CDT