Re: Oracle Built in Packages?

From: Maija-Leena Kangasmäki <maija-leena.kangasmaki_at_tietogroup.com>
Date: Thu, 16 Jul 1998 10:42:42 +0300
Message-ID: <35ADAEF2.22D43B64@tietogroup.com>

You can use: DESC UTL_FILE.GET_LINE in SqlPlus.

LNTVR_SQL> DESC UTL_FILE.GET_LINE
PROCEDURE UTL_FILE.GET_LINE

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 FILE                           RECORD                  IN
   ID                           BINARY_INTEGER          IN
 BUFFER                         VARCHAR2                OUT

LNTVR_SQL> Regards,

Maija-Leena

Kathy Graham wrote:

> Hi Folks;
> I am a new PL/SQL programmer. I am trying to use the UTL_FILE
> package to read and write files and have a few questions.
>
> - How do I obtain the parameters that a package function expects?
> Specifically, I am trying to use the Get_Line function of UTL_FILE but
> am getting an error that I have the wrong number of parameters. However
> the very sparse documentation that I can find seems to show that I
> should only need:
>
> /* Read in file record */
> UTL_File.Get_Line (file_handle => READ_FILE_HANDLE,
> buffer => vLineOfText);
> 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.
>
> Kathy Graham
> kathy_graham_at_hpl.hp.com
Received on Thu Jul 16 1998 - 02:42:42 CDT