Re: Question about utl_file

Devyani,

A stupid question, I hope: have you stupped and re-started the database> (Just checking!<g>)

In addition to checking OS rights, check your spelling - so easy to make a typo.

Have you included wildcard characters? Despite appearances, with the exception of a simple * (which is a definite no-no), Oracle doesn't seem to support wildcards (in 7.3 anyway).

Len

>Hi.
>
>I'm trying to use the utl_file package in Oracle 7.3 to read a flat file
>(UNIX). I've updated the init.ora file to include the parameter utl_file_dir
>which specifies the accessible directory path (as described in the
>documentation). However, the function in utl_file still returns an error for
>invalid path. I can't seem to find the problem and would welcome any
>suggestions on what to look for.
>
>Please reply to maestro_98_at_hotmail.com.
>
>Thanks,
>Devyani
>
Received on Mon May 31 1999 - 15:21:38 CDT