Page 1 of 1

Interfaces

Posted: Tue Jan 22, 2008 1:59 am
by kareem2003
IN purchase
I have 100 lines inthat
80 lines in interface table as other 20 errors
20 lines in the error table .
how can i use add the 20 lines in interface table
can i use SQL LOADER where i can use add or skip,rows ?
or
delete data in the Interface table and do it same process?
.
my mail id kareem2003@gmail.com

have a nice day

Posted: Tue Jan 22, 2008 2:12 am
by raviteja.manchu
Hi,

Correct the error lines in the interface table and again upload those lines and import the same into the application

Regards,
Ravi Manchu

Posted: Fri Feb 01, 2008 3:07 am
by rehmans
Why are you using SQL Loader? Try using Toad or PLSQL Developer for this purpose. It's a lot easier than SQL Loader.

Posted: Fri Feb 01, 2008 7:33 am
by kareem2003
Thanks Ravi,
I know that process next time i do that .

now data at Stagetable at 100 lines.
IF i can validated data and Insert into Interface table ,
But 90 lines at going to the Interface table .10 at the error
How i can insert thouse 10 lines.
plz tell me .
wait for u replay.

Have a nice weekend.