| UTL_FILE on VAX VMS [message #440360] |
Fri, 22 January 2010 15:36  |
mcykowski
Messages: 1
Registered: January 2010
|
Junior Member |
|
|
Does anyone know if or how I can get UTL_FILE PL/SQL installed on my VAX VMS system? My research tells me that UTL_FILE was released only with Oracle 7.3 and above. Any way to get around this restriction to get UTL_FILE installed with Oracle 7.1.3.2.0?
Is it worth it to try and change the INIT.ORA and see what happens? Not being a DBA, would this mess up Oracle forever? 
The OS is VAX VMS V5.5-2, Oracle version is 7.1.3.2.0, and PL/SQL version is 2.1.3.2.0.
|
|
|
|
|
|
| Re: UTL_FILE on VAX VMS [message #440854 is a reply to message #440360] |
Wed, 27 January 2010 06:58  |
daverich
Messages: 23
Registered: January 2010
Location: UK
|
Junior Member |
|
|
To find out if utl_file is installed in your database run
select owner, object_name, object_type from dba_objects where object_name like '%UTL_FILE%';
If the package is there then you have to set a parameter in your init.ora file and restart your database.
If you are using VMS then you will be giving a path like
utl_file_dir = ORATEST_SYS$COMMON:[TMP]
This is the directory that utl_file can read/write. You will need execute permission to use UTL_FILE (DBA should be able to give that)
But as Michel Cadot said, your version does not support it, so you can't do that...if that is the case.
[Updated on: Wed, 27 January 2010 07:02] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
