Re: Oracle Built in Packages?

>Is there a way to query the package to get this information? (I am
>running 7.3 if this matters.) Thanks in advance for any assistance.

The file handle is returned when you use file_open.

In general, there are two options:

    desc utl_file.get_line

or -- by head --

    select text
    from all_source
    where name = 'UTL_FILE'
    and type = 'PACKAGE'
    order by line;

If you're lucky, then even the source is available:

    and type = 'PACKAGE BODY'

I'll send you an example on using utl_file by e-mail. Note that in init.ora one or more lines like

    utl_file_dir = ...

should exist, for each and every directory and all of its subdirectory you wish to access (or utl_file_dir = * if you want to open up the whole system). Finally, user oracle should be able to access those directories.

Arjan. Received on Wed Jul 15 1998 - 14:49:15 CDT