Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file_dir parameter and create directory object

3180Jun 16 2005 — edited Jun 17 2005
We are on 9iR2.

So far, we have been using the utl_file_dir parameter to nominate the directories we can access using utl_file on the host machine, but with the new create directory object format, can we use both of them together ?

What I mean is that can the existing programs keep using the directories set in utl_file_dir parameter but the new ones can create their own directory objects.
Or its a either/or situation ?

I would like to use external table and I believe for that we must use the directory object, is that right ?

thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2005
Added on Jun 16 2005
3 comments
322 views