on "_system_trig_enabled" parameter setting

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 12 2007 - 09:32:58 CDT