Trying to run catproc.sql with no luck. 2004-02-20 - By Tim Johnston
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 (See ORA-03113.ora-code.com): 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@(protected)
>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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
