Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Streams setup environment Problem

Streams setup environment Problem

From: shahsyed <shahsyed_at_gmail.com>
Date: 8 Aug 2005 01:12:22 -0700
Message-ID: <1123488742.407304.149810@g14g2000cwa.googlegroups.com>


Hi to All experts in areana
when i run this script

BEGIN
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(

    privilege     => DBMS_RULE_ADM.CREATE_ANY_RULE_SET,
    grantee       => 'STRM_ROLE',
    GRANT_option  => TRUE);
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.ALTER_ANY_RULE_SET,
    grantee       => 'STRM_ROLE',

    GRANT_option => TRUE);
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.EXECUTE_ANY_RULE_SET,
    grantee       => 'STRM_ROLE',
    GRANT_option  => TRUE);
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.CREATE_ANY_RULE,
    grantee       => 'STRM_ROLE',

    GRANT_option => TRUE);
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.ALTER_ANY_RULE,
    grantee       => 'STRM_ROLE',
    GRANT_option  => TRUE);
   DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
    privilege     => DBMS_RULE_ADM.EXECUTE_ANY_RULE,
    grantee       => 'STRM_ROLE',

    GRANT_option => TRUE);
  END; i receive the following error messages

ORA-03113: end-of-file on communication channel

Plz help mee in this regard
Thnks in Advance Received on Mon Aug 08 2005 - 03:12:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US