What's in the alert log? Any trace files being generated? Thomas Day wrote: >Windows 2K, Oracle 9.2. > >Any ideas gratefully accepted (except change operating system - that's not >within my scope). > >SQL> DECLARE > 2 vt sys.re$variable_type_list; > 3 BEGIN > 4 vt := sys.re$variable_type_list( > 5 sys.re$variable_type('DML', 'SYS.LCR$_ROW_RECORD', > 6 'SYS.DBMS_STREAMS_INTERNAL.ROW_VARIABLE_VALUE_FUNCTION', > 7 'SYS.DBMS_STREAMS_INTERNAL.ROW_FAST_EVALUATION_FUNCTION'), > 8 sys.re$variable_type('DDL', 'SYS.LCR$_DDL_RECORD', > 9 'SYS.DBMS_STREAMS_INTERNAL.DDL_VARIABLE_VALUE_FUNCTION', > 10 'SYS.DBMS_STREAMS_INTERNAL.DDL_FAST_EVALUATION_FUNCTION')); > 11 > 12 dbms_rule_adm.create_evaluation_context( > 13 evaluation_context_name=>'SYS.STREAMS$_EVALUATION_CONTEXT', > 14 variable_types=>vt, > 15 evaluation_function=> > 16 'SYS.DBMS_STREAMS_INTERNAL.EVALUATION_CONTEXT_FUNCTION'); > 17 EXCEPTION WHEN OTHERS THEN > 18 IF SQLCODE = -24145 THEN > 19 -- suppress evaluation context already exists error to minimize > 20 -- unwanted noise during upgrade. > 21 NULL; > 22 ELSE > 23 RAISE; > 24 END IF; > 25 END; > 26 / > >PL/SQL procedure successfully completed. > >SQL> >SQL> begin > 2 dbms_rule_adm.grant_object_privilege( > 3 privilege=>dbms_rule_adm.EXECUTE_ON_EVALUATION_CONTEXT, > 4 object_name=>'SYS.STREAMS$_EVALUATION_CONTEXT', > 5 grantee=>'PUBLIC', grant_option=>FALSE); > 6 end; > 7 / >begin >* >ERROR at line 1: >ORA-03113: end-of-file on communication channel > > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >put 'unsubscribe' in the subject line. >-- >Archives are at //www.freelists.org/archives/oracle-l/ >FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > > -- Regards, Tim Johnston Tel: 978-322-4226 Fax: 978-322-4100 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------