Home » SQL & PL/SQL » SQL & PL/SQL » Traversing line by line using UTL_FILE package
Traversing line by line using UTL_FILE package [message #7762] Mon, 07 July 2003 06:04 Go to next message
Joseph
Messages: 30
Registered: June 2002
Member
I have a property file wherein i have key value pairs. The property file has some 20 lines. I need to go to each and every line give a key name and get the value for that key name.

I am able to do that if there is only one line in the property file. This is achieved thru UTL_FILE.GET_LINE

thanks in advance

Report message to a moderator

Re: Traversing line by line using UTL_FILE package [message #7768 is a reply to message #7762] Mon, 07 July 2003 12:10 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Why not just read the whole file in, once per session, to an array or global temporary table and search that as needed? It will be much more efficient than O/S file I/O.

Report message to a moderator

Previous Topic: Want Logic for the Data Process
Next Topic: performance issues
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:48:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.