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: 63917
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: Select from different database
Next Topic: tkprof
Goto Forum:

Current Time: Mon Oct 24 19:02:38 CDT 2016

Total time taken to generate the page: 0.11928 seconds