| SQLLoader [message #71231] |
Fri, 27 September 2002 05:15  |
kaspyanand
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
Hi,
for our project we have to run a job-
everyday employees punch-in,which is collected in a flatfile.this flatfile is send to our server through ftp.Now,we have to load the data from the flat file into the oracle8 databse table called attendance.How can we automate this process?
we are thinking of making a dll which will execute the sqlloader,which will execute a stored procedure for processing the flatfile
but how to go about it?how to write the dll ?there are many issues.
any help will be great!!
thanks
|
|
|
|
|
|
| Re: SQLLoader [message #71234 is a reply to message #71231] |
Fri, 27 September 2002 08:06  |
kaspyanand
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
but my problem is-how to invoke sqlloader from a stored procedure.
i will get a flatfile,which needs to be processed.so we are thinking to call sqlloader from stored procedure.then sqlloader will read the flatfile,and enter data into the table.this whole process needs to be scheduled activity
thanks
|
|
|
|
| Re: SQLLoader [message #71236 is a reply to message #71231] |
Fri, 27 September 2002 20:36 |
kaspyanand
Messages: 5
Registered: September 2002
|
Junior Member |
|
|
Hi,
i am getting error when i run the batch file
invalid username/password:login failed
sqlloader 704-internal error-ulc connection failed
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
