RE: Utl_file and OPENVMS

Hey Ron,

If I'm not mistaken, access to the UTL_FILE directories needs to be given to the account that started the Oracle instance and not an Oracle schema name.

Also, make sure that your entries for the filenames and directories in the UTL_FILE packages are UPPER CASE, or at least match the init.ora parameter UTL_FILE_DIR in case. ODS-2 volumes in VMS (the only one supported by Oracle for 8i) only allow UPPER CASE file names. It's probably a good idea to uppercase the RMS filenames and directories in your procedure and in the init.ora

Make sure the file you are creating is a valid VMS name. From DCL in the Oracle instance's account (default is "ORACLE"), try "CREATE myfilename", where "myfilename" is the exact name that would be passed to UTL_FILE, with the directory. If this succeeds, you can terminate the CREATE statement with a <CTRL-Z> or <CTRL-C> in most cases. Also, beware that because DCL automagically uppercases everything in the command line that isn't in quotes, the CREATE is not a good test for case-sensitivity.

HTH! GL! :)

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> Sent: Monday, September 30, 2002 9:53 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Utl_file and OPENVMS
>
>
> List,
> I have a package that creates files on the server. The directory
> location and file name are obtained from tables in oracle.
> The procedure
> works as designed on Novell 7.3.4 and no changes were needed when the
> database way loaded on Linux Oracle 8.1.7. I am trying to move the
> database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't
> get the package to write the files to the OS directory.
> The package is created by the Oracle user DTSUSER and executed by
> DTSUSER. There is no OPENVMS user DTSUSER.
> The sysadmin assures me that the permissions are correct to write to
> the directory.
> I have place a Dbms_output in the package to display the directory
> information and it looks correct.
> Is there anything different that has to be done to an OPENVMS server
> that will allow a package to write to a directory using the Utl_File
> package?

[snip]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).