Re: on "_system_trig_enabled" parameter setting

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

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