topic Re: UTL_fILE in Operating System - HP-UX

UTL_fILE

Rajkumar_3 — Tue, 16 Oct 2001 11:27:39 GMT

Hai,

I have a text file which contains rows upto 1M.
Instead of using SQLLOADER I want to use UTL_FILE concept to insert those records into the
different oracle tables.

Can any one have an idea ,If have please provide an example..

Thanks for the Advance in Help..

Regards
Rajkumar

Re: UTL_fILE

harry d brown jr — Tue, 16 Oct 2001 14:16:59 GMT

Take a look at this:

http://www.elementkjournals.com/dbm/0005/dbm0053.htm

Re: UTL_fILE

Steve Slade — Wed, 17 Oct 2001 05:53:47 GMT

Hi,

I have never done any file reading using UTL_FILE, although I have used to write out to files. As Oracle features go, it is pretty poor: it has poor error handling, and is pretty slow - especially compared to SQL-LOADER.

Good Luck

Steve

Re: UTL_fILE

Andreas D. Skjervold — Wed, 17 Oct 2001 05:56:07 GMT

Hi

check the enclosed note from Oracle Metalink. Here you'll find how to set up a function to read and write from/to files:

To read from files, check the following section of the note:
-- Open the same file to read from
file_handle :=
UTL_FILE.FOPEN('/tmp','myfile.txt','R');

-- Read a line from the file.
UTL_FILE.GET_LINE (file_handle, retrieved_buffer);

-- Print fetched line out to the SQL*PLUS prompt.
DBMS_OUTPUT.PUT_LINE(retrieved_buffer);

-- CLose the file.
UTL_FILE.FCLOSE(file_handle);

Andreas

Re: UTL_fILE

Andreas D. Skjervold — Wed, 17 Oct 2001 07:15:09 GMT

SQL*Loader, specially using direct path, loads fast but within sqlloader, you cannot add logic such as "if the row exists then update else insert".
If this is what you need to do, then you will use the UTL_FILE package.

Andreas

Re: UTL_fILE

Alexander M. Ermes — Wed, 17 Oct 2001 07:26:38 GMT

Hi there.
Go for the sqlloader.
Faster, easier to handle.
If you read the manual, check for ctl files
( param files for sqlloader ).
There you can set conditions for the load.
Rgds
Alexander M. Ermes

Re: UTL_fILE

Rajkumar_3 — Wed, 17 Oct 2001 09:14:36 GMT

Hai All,

Thank you for your reples..

I will try using these options which i have recieved from you all and i will let you know the result..

Thanks & Regards
Rajkumar