Re: PL/SQL error returning in OEM12c
- From: MARK BRINSMEAD <mark.brinsmead@xxxxxxxxx>
- To: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- Date: Tue, 17 Mar 2015 20:05:47 -0400
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@xxxxxxxxx>
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?????
>
>
>
>
>
>
>
Other related posts:
