RE: UTL_FILE ISSUE

I have, it shows succeeded and the additional info field where errors are
typically shown is null.

 

Thanks,

Ken

 

From: chet justice [mailto:chet.justice@xxxxxxxxx] 
Sent: Monday, May 03, 2010 2:06 PM
To: rjamya@xxxxxxxxx
Cc: Richard.Goulet@xxxxxxxxxxx; kennethnaim@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: UTL_FILE ISSUE

 

Have you checked the view for any error messages?

I believe it is DBA_SCHEDULER_JOB_RUN_DETAILS

If there is an error, it is written there.




On Mon, May 3, 2010 at 1:22 PM, rjamya <rjamya@xxxxxxxxx> wrote:

I agree with Dick, the problem could be with privs, try with direct privs to
the package owner rather than via role.

 

On Mon, May 3, 2010 at 1:11 PM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>
wrote:

Ken,

       On thing I can think of is what are the permissions on the
directory?  Are they inherited through a role, if so to run as you
specify they will need to be directly granted.

Other related posts: