In 10g utl_file = /oracle/utl/write
in other words no trailing slash for the last directory

>>> "Luis Cardenas "
<oracledba-ezmlmshield-x68203997.[Email address protected] 3/5/2007
11:19:24 >>>
Gurues,



there is a file system (mount point) which I am not being able to
writ
to from within my Oracle 9i Solaris system. The directory is owned by
jboss and oracle has been added this jboss so that when I logon as
oracle at OS level and touch a file it is created with oracle as the
user but jboss as the group.



therefore the privs setting is 2775 meaning uid is set.



Now from within a stored procedure I am not being able to write to the
directory on which note the utl_file_directories are not being
terminated by a "/" and I can not remember if this is correct or not.



Your advise is appreciated.



Luis Cardenas













-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page