Home » SQL & PL/SQL » SQL & PL/SQL » BULK insert (sql 2000)
BULK insert [message #356930] Mon, 03 November 2008 04:36 Go to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
hi,

i am using a bulk insert to insert data from plain text file.

the records are terminated by !

when i use bulk insert i get that

Server: Msg 4832, Level 16, State 1, Line 1
Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.

What could be the possible reasons?

thnx.
Re: BULK insert [message #356932 is a reply to message #356930] Mon, 03 November 2008 04:41 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
what is the script file contents (loader)
Re: BULK insert [message #356933 is a reply to message #356930] Mon, 03 November 2008 04:43 Go to previous message
Michel Cadot
Messages: 64116
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not an Oracle error message.
Investigate the program that executes the process.
Obviously it reaches the end of the file before it completes to process the preceding step. A missing '!'?

Regards
Michel
Previous Topic: date & calendar table
Next Topic: insert with condition
Goto Forum:
  


Current Time: Tue Dec 06 02:19:45 CST 2016

Total time taken to generate the page: 0.24759 seconds