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,