Re: PL/SQL error returning in OEM12c

From: raza siddiqui <raza.siddiqui_at_oracle.com>
Date: Tue, 17 Mar 2015 13:16:00 -0700
Message-ID: <55088B80.7030009_at_oracle.com>

What account (hence permissions) are being used to run this script ?

On 3/17/2015 11:54 AM, 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?????
>

-- 
Oracle <http://www.oracle.com>
Raza Siddiqui | Senior Principal Curriculum Product Manager (DB Server)
Phone: +1 650 506 2268 <tel:+1%20650%20506%202268> | Mobile: +1 408 387 
4928 <tel:+1%20408%20387%204928>
Oracle Oracle University - Products & Services
500 Oracle Parkway, MS 4IP3 | Redwood Shores, CA 94065
Green Oracle <http://www.oracle.com/commitment> Oracle is committed to 
developing practices and products that help protect the environment

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

Received on Tue Mar 17 2015 - 21:16:00 CET