Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cron and UTL problem
I suspect that you will find that it is a permissions problem and that if
you execute the cron job as a user that is a member of the dba group all
will be fine. Note this is a suspicion and not a cast iron diagnosis.
-- Niall Litchfield Oracle DBA Audit Commission UK "David" <kokirulo1980_at_yahoo.es> wrote in message news:cf2dd774.0304280618.763b7f26_at_posting.google.com...Received on Mon Apr 28 2003 - 09:43:09 CDT
> Hello, thanks and sorry for my english:
>
> I have a very huge problem I try to explain correctly:
>
> I have a shell that calls a pl-sql program, after a pro-cobol program
> and after another pl-sql program. This shell works correctly and do
> every thing that I want. The problem is when I put into the cron, the
> first pl-sql programs works ok, the procobol too and the last pl-sql
> exists for the exception SYS.UTL_FILE.INVALID_OPERATION. This pl-sql
> opens one file for reading and four for writing, and when is trying to
> open the third file exists for the mentioned exception.
>
> I like to be clear about this shell works correctly when I execute in
> a normal unix sesion and its when I put in the cron when fails.
>
> Thanks
>
> David