finding error in a particular column while uploading from excel to database [message #257307] |
Wed, 08 August 2007 01:25 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sathyam2627
Messages: 52 Registered: November 2006
|
Member |
|
|
Hi to all,
I am uploading data from excel to database by using DDE.REQUEST and i am trying to do this from front end using forms.
In my table morethan 60 fields are there. while uploading somewhere 1 field is causing problem. i would like to display the field name where error arises.If anybody is having a solution,please tel me
Anybody can help me from this,by giving a solution for the same.
Regards
sathya..
|
|
|
|
Re: finding error in a particular column while uploading from excel to database [message #257365 is a reply to message #257330] |
Wed, 08 August 2007 03:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sathyam2627
Messages: 52 Registered: November 2006
|
Member |
|
|
HI,
First of all let me thank your reply.
Error code might be anything, if any column finds the error while uploading data just i wanted to display that column name.
I am uploading thousands of data into my database. so that i not able to tel you the error code. suppose for example a column invoice_date, if this column is not accepting the data then i want to display that column name..
We are using forms9i release 2 Developer suite.
Database is Oracle9i release 2
Regards
sathya...
|
|
|
|