Re: All jobs are failing with ORA-01427 -- solved

Sybrand Bakker wrote:

> On Thu, 10 Jul 2003 09:35:09 -0700, Anne Nolan
> <MUNGEanneDOTnolanNOSPAM_at_rts-group.com> wrote:
>
> >On further digging (into a different database on a different server we also
> >have), I've discovered that all jobs are failing with the same error:
> >ORA-12012: error on auto execute of job 21
> >ORA-01427: single-row subquery returns more than one row
> >ORA-06512: at line 11
> >
> >Some of these jobs are for materialized view refreshes, while others just run
> >a stored procedure.
> >
> >Both servers run Oracle 8.1.7.0.0
> >One is WinNT4 SP6, while the other is Windows 2000 Version 5.0.
> >
> >Can anyone shed any light as to what's going on?
> >
> >Thanks for any help,
> >
> >Anne Nolan
> >
> >
> >
> >
>
> Isolate the query and execute it independently.
> Alternatively set event='1427 errorstack trace name level 3' in your
> init.ora and bounce the database
>
> >
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Sybrand, I followed your advice for getting the error trace and got the problem solved. (Turns out it was a Logoff trigger that was generating the error.)

Thanks again for pointing me to a way to get the solution.

Anne Nolan Received on Fri Jul 11 2003 - 09:43:32 CDT