Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE: is there a max number of records
UTL_FILE: is there a max number of records [message #40516] Tue, 15 October 2002 10:07 Go to next message
Tom Felton
Messages: 3
Registered: October 2002
Junior Member
I am attempting to use UTL_FILE to read a fixed format text file and then INSERT or UPDATE into an Oracle table depending on existence of the record. For some reason the procedure always stops once 5204 records are processed. If my datafile has fewer that 5204, everything is OK.

Any ideas would be appreciated. I'm running on Sun Solaris 2.6, Oracle 8.1.5.

Report message to a moderator

Re: UTL_FILE: is there a max number of records [message #40517 is a reply to message #40516] Tue, 15 October 2002 10:43 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Can you clarify what you mean by "stops"? Does your proc terminate or just seem to hang?

Report message to a moderator

Re: UTL_FILE: is there a max number of records [message #40520 is a reply to message #40516] Tue, 15 October 2002 15:19 Go to previous message
Andrew
Messages: 144
Registered: March 1999
Senior Member
is there any chance that you have dbms_output in the code which is hitting your buffer limit (and the error is being suppressed)?

Report message to a moderator

Previous Topic: Passing ref cursor between procedures.
Next Topic: LOCK TABLE XYZ IN SHARE UPDATE MODE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 03 01:43:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.