Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE file handling capacity
UTL_FILE file handling capacity [message #234513] Tue, 01 May 2007 23:03 Go to next message
Messages: 7
Registered: January 2006
Junior Member

We have some Pro*C programs which creates extracts from the database. We are planning to convert these into PL/SQL procedures. However, these files can be quite big at times. I wanted to know if there is any limitation in using UTL_FILE or any other packages on the size of the files. We are using Oracle on HP-UX B.11.11

Re: UTL_FILE file handling capacity [message #234544 is a reply to message #234513] Wed, 02 May 2007 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
utl_file writes line per line, as does Pro*C, you have the same limitation.
Remember Pro*C program writes where it is executed (i.e. on the client), PL/SQL writes on the database server.

Re: UTL_FILE file handling capacity [message #236730 is a reply to message #234544] Thu, 10 May 2007 14:01 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
UTL_FILE is traditionally quite slow, but things change over time, so you need to benchmark it. utl_file in 9.2.x can be considered slow.



Previous Topic: How do I sum a value? (merged)
Next Topic: 10G Issue
Goto Forum:

Current Time: Sat Aug 19 11:53:55 CDT 2017

Total time taken to generate the page: 0.01181 seconds