Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Suggestions - DOS Command - Return value
Forgot to mention another important difference between PL/File and utl_file:
Through PL/File multiple services can be started. Each service can be
started by a
specific user, so you can use different access rights for different
services.
Within UTL_FILE you only can use the ORACLE operating system user. This
means that the paths for
the ORACLE user always have to be used or specific access rights to other
paths
must be granted to the ORACLE operating system user.
regards,
--TS
> Well, there are quite a few differences between the PL/File package and
> utl_file :
>
> - PL/File offers access to files and directories locally -and- remotely
> (with secure access)
> - PL/File offers a lot more file functions
> - PL/File has file list functions
> - PL/File offers ZIP file functions
> - PL/File offers extended directory functionality
> - PL/File offers file find with regular expression search
> - All PL/File functionality Oracle 8.1.7+ (mentioned enhanced utl_file
only
> in 9.2)
>
> More information can be found at www.plfile.com
>
> Kind regards,
>
> www.semantica.com
> --TS
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 03-10-02Received on Fri Oct 04 2002 - 08:52:38 CDT
![]() |
![]() |