Trying to run catproc.sql with no luck.

From: Thomas Day <tday6_at_csc.com>
Date: Fri, 20 Feb 2004 14:57:31 -0500
Message-ID: <OF24DF10A5.8896EA13-ON85256E40.006D779C@csc.com>

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

---

Received on Fri Feb 20 2004 - 15:35:50 CST