You can use the table ALL_ARGUMENTS to see all procedures and functions with
their arguments.
In your case, UTL_FILE.GET_LINE() requires a FILE, ID & BUFFER as arguments.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Kathy Graham wrote in message <35ACDFE5.21D348E8_at_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 - 13:39:26 CDT
