Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!chekhov.conxion.net!news.oracle.com!not-for-mail
Message-ID: <42F75F25.4030504@gmail.com>
From: amogh <amogh.r@gmail.com>
Reply-To:  amogh.r@gmail.com
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Streams setup environment Problem
References: <1123488742.407304.149810@g14g2000cwa.googlegroups.com>
In-Reply-To: <1123488742.407304.149810@g14g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 42
Date: Mon, 08 Aug 2005 19:03:25 +0530
NNTP-Posting-Host: 152.69.155.88
X-Trace: news.oracle.com 1123508941 152.69.155.88 (Mon, 08 Aug 2005 06:49:01 PDT)
NNTP-Posting-Date: Mon, 08 Aug 2005 06:49:01 PDT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249097

shahsyed wrote:
> 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
> 
Runs fine when I executed it in SQL* Plus!

Regards,
Amogh