Re: PL/SQL error returning in OEM12c

From: MARK BRINSMEAD <mark.brinsmead_at_gmail.com>
Date: Tue, 17 Mar 2015 20:05:47 -0400
Message-ID: <CAAaXtLBbepigqjZxc0dzJAQAF=bmbDTyse7moN_rwBPfRbr+zw_at_mail.gmail.com>

Or maybe consider a SYSLOG interface directly from PL/SQL. I bet one exists already (I've never looked), but if it doesn't you could probably code one on top of UTL_TCP in an hour or so.

There are lots of options. Almost all of them better than DBMS_OUTPUT. :-)

On Tue, Mar 17, 2015 at 7:47 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

> In addition to some of the other suggestions, you might consider tying
> into Log4J framework using http://log4plsql.sourceforge.net/
>
> /Hans
>
>
>
> On 17/03/2015 12:54 PM, John Jones wrote:
>
> I have been away from PL/SQl programming for quite some time and have
> been bumping my head about the following problem with PL/SQL and OEM 12c.
>
>
>
> I want to submit a PL/SQL program to perform the following in over 100
> databases and do not want to scan each output for errors.
>
>
>
> I am writing code that will select the number of users that have an OPS$
> account. There should be 7 in each database, so I wrote a SQL Script that
> just select to count(*) of records into a variable and then check the
> results of that. If count(*) = 7 then everything is ok and I don’t need to
> know anymore. If the count(*) < 7 then I want the program to error out and
> return “something” so that I know which databases to check.
>
>
>
> declare
>
> holder number;
>
> begin
>
> select count(*) into holder from all_users where username like 'OPS$%';
>
> if holder = 7 then
>
> dbms_output.put_line('the count is '||holder);
>
> elsif
>
> holder < 7 then
>
> raise_application_error(-20010,'Users do not exists');
>
> end if;
>
> end;
>
>
>
> If I run this from SQL*Plus, I get an error and it prints users do not
> exists, but if I run this in OEM 12c, it tell me the job completed. Also I
> am getting no ouput on any of the jobs.
>
>
>
> Ideas?????
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 18 2015 - 01:05:47 CET