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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Feb 2004 16:16:52 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607AFFFF4@EXCHMN3>

Thomas - Check the alert log for clues.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: Thomas Day [mailto:tday6_at_csc.com]
Sent: Friday, February 20, 2004 1:58 PM
To: oracle-l_at_freelists.org
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_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


-----------------------------------------------------------------

----------------------------------------------------------------

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

Received on Fri Feb 20 2004 - 17:11:18 CST