Re: Trying to run catproc.sql with no luck.

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_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------