Thomas - Check the alert log for clues. Dennis Williams DBA Lifetouch, Inc. dwilliams@xxxxxxxxxxxxx -----Original Message----- From: Thomas Day [mailto:tday6@xxxxxxx] Sent: Friday, February 20, 2004 1:58 PM To: oracle-l@xxxxxxxxxxxxx Subject: Trying to run catproc.sql with no luck. 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------