| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: on "_system_trig_enabled" parameter setting
The ORA-1422 looked suspiciously like a symptom
of >1 row in dual.
That is no longer supposed to be possible ( I think beginning with 9i), but, you never know.
Jared
SQL> alter user test identified by welcome
-- ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows On 3/12/07, Bala <oratips_at_gmail.com> wrote:Received on Mon Mar 12 2007 - 18:10:10 CDT
>
> ###
> 17:09:42 NVUATDB > select * from dual;
>
> D
> -
> X
>
> Elapsed: 00:00:00.02
> ###
>
> 17:09:45 NVUATDB > select * from x$dual;
>
> ADDR INDX INST_ID D
> ---------------- ---------- ---------- -
> 0000000102E229E0 0 1 X
>
> Elapsed: 00:00:00.01
> ###
> Thank you Very much for the reply.
>
> Bala --
>
>
>
> On 3/12/07, Jared Still <jkstill_at_gmail.com> wrote:
> >
> > What are the results of running these queries?
> >
> > select * from dual;
> >
> > select * from x$dual;
> >
> >
> >
> > On 3/12/07, Bala < oratips_at_gmail.com> wrote:
> > >
> > > 1) I am getting ORA-06553: PLS-213: package STANDARD not accessible,
> > > temporary workaround i am doing is setting init.ora parameter
> > > "_system_trig_enabled=false" and recreate standard package.
> > > 2) If i dont do the above , i cant even chanage users password , get
> > > the following
> > >
> > > SQL> alter user test identified by welcome
> > > --
> > > ERROR at line 1:
> > >
> > > ORA-00604: error occurred at recursive SQL level 1
> > >
> > > ORA-01422: exact fetch returns more than requested number of rows
> > >
> > > ORA-06512: at line 11
> > > 3) any insight is very much appreciated. Thanks for your time.
> > >
> > >
> > > Solaris 2.9, Oracle 9.2.0.6
> > >
> > > Regards,
> > >
> > > --
> > > Bala Rao
> > >
> >
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
>
>
> --
> Bala Rao
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l
 |
 |