Re: script wont run in sqlplus

Hi -

Hi the corresponding built_in on the server is utl_file.

You may run into the write permission problem even though the error message may not necessarily indicate it.

At least on our 7.3.3 UNIX release the utl files are written under user oracle.

You also want to make sure that you have the following line in your init.ora file and then stop and start the database for it to take effect. * means any directory/sub-directory where user oracle has permission to write a file.

  utl_file_dir = *  

     AND/OR   utl_file_dir = /var/tmp

Later !!!

Suresh Bhat
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Bob <bookor_at_mail.org> wrote in article <7lnmg6$d79$1_at_nntp2.atl.mindspring.net>...
> Why wont a plsql script that will run from a button on a forms 4.5 form
> refuse to run from sqlplus?
>
> the only odd thing used in the script is text_io.
>
>
> thanks for any replies
>
> bookor_at_interserv.com
>
>
>
>
Received on Wed Jul 07 1999 - 17:03:44 CEST