Re: Need Help with some PLSQL code please

bsc7080mqc_at_mylxhqremoveme.com wrote:

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

Ultimately you did yourself no good by not identifying that you were talking about Oracle Apps. ;-)

If you want to be able to report ... use a report writer. Oracle has two fine examples. Third-party vendors have them too.

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