Re: Need Help with some PLSQL code please

<bsc7080mqc_at_mylxhqremoveme.com> wrote in message news:tx99b.10726$Ci3.7496_at_bignews3.bellsouth.net...
| 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.

[snip]

Thanks for your reply, but unfortunately we don't use 'Oracle Applications', nor would I be allowed to if we did :-).

The table I have been writing this procedure for, is in effect a table that has all the errors logged into it. All I need to do, is query this table for specific error(s) that have been logged.

An error description is logged against the first argument to my procedure (1 to 15, for a given date of course), and that's all.

There are never many errors, so the usage of the procedure will be very low. At the moment, we manually type in the query to find what we are looking for in SQL*PLUS, and this procedure was supposed to eliminate more typing, and the chance of typing in something wrong, in a production system.

I am still very new to PL/SQL, and really would appreciate some feedback on what I last posted, because I am interested in learning this stuff at the end of the day.

Thanks for your time.
Chris Val Received on Mon Sep 15 2003 - 07:58:57 CDT