Re: DBMS_PIPE - Sending email
Date: 2 Apr 2002 23:39:49 -0800
Message-ID: <a20d28ee.0204022339.758d04db_at_posting.google.com>
adityanath_at_hotmail.com (Aditya) wrote in message news:<4a5a78d4.0204021352.434f5eac_at_posting.google.com>...
> Hi!
>
> I have a batch process that runs every night and creates a log file on
> Unix (Sun OS). I need to email this log file to a email address.
>
> I tried using DBMS_PIPE in my function.
> But when I complie the function it gives the error
>
> PLS-00201: identifier 'SYS.DBMS_PIPE' must be declared
>
> I thought this user doesn't have execute permission on this package.
>
> Then I logged in as system and tried
>
> grant execute on DBMS_PIPE to dash
>
> It gives this error
>
> ORA-01031: insufficient privileges
>
> I don't know what to do.
>
> Would I be able to send email from my procedure.
> Please advice.
>
> Regards,
> Aditya
The owner of DBMS_PIPE is SYS, not SYSTEM only owners can grant privilege or a grantee must have been granted privilege with admin option. This isn't true for SYSTEM. connect as SYS and retry.
Regards
Sybrand Bakker,
Senior Oracle DBA
Received on Wed Apr 03 2002 - 09:39:49 CEST