Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Streams setup environment Problem
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
Received on Mon Aug 08 2005 - 08:33:25 CDT