Oracle Built in Packages?

From: Kathy Graham <kathy_graham_at_hpl.hp.com>
Date: Wed, 15 Jul 1998 09:59:17 -0700
Message-ID: <35ACDFE5.21D348E8@hpl.hp.com>

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 Wed Jul 15 1998 - 11:59:17 CDT