DSXchange

array size is already 1

there is no issue with the parameter....i checked....also am using autogenerated querry....

i have used OCI.... i am reading from a seq. file then transformer then OCI.... though data is getting read properly...it is showing below error in Director... ldiuICVEcoupon..xfm: ORA-00911: invalid character The value of the row is: COUPON_SET_NBR = 46 COUPON_SEQ_NBR = 4905 ECOUPON_ID = 7701993900...

there is no problm about the quotes.....
also i have validated the data it is correct only.

i am trying to insert update data into oracle table and i am getting ora - 00911 error. my data is clean only--- Input data is-- 46|4905|"7701993900100044980253"||||"2009-02-16 04:00:01"||"2009-02-13 16:50:31" 46|4906|"7701993900100044990268"||||"2009-02-...

So...Do we need to prepare control files also...?
or DS will prepare and we just need to mention the path...?

What is oracle bulk load stage?
how it is different from ordinary oracle stage?

thats a v gud suggesion.
Will do that....any ways we are good in that.....

yes those special characters are available in remote file...
so is there no way to avoid it....
as that remote file will be comming from third party company

well through shell script i am importing the files..... it never happened with any other file but only with this file it is happeing.... so i want to know whether it is the sourse file problem... by using CAT i am concatinating the files,......in shell script... also....is there any way by which we ...

Actually i am importing file from remote location then....i am concatinating it with a available file..... so the specila characters are comming.... not sure whether it is happening coz of transfer or coz of input sourse.... bt one thing which i observed.... when i am copy pasting the data into a ne...

well is there any way to eliminate it without doing manual work....

Hi after checking od -c i got this -----> 0000000 357 273 277 ' 4 8 3 1 1 ' , ' B B 2 ' 0000020 , ' 0 1 / 1 6 / 2 0 0 9 ' , ' 1 0000040 6 : 3 3 : 1 5 ' , ' 0 0 0 0 7 0 0000060 0 0 6 7 0 0 1 1 0 2 7 2 5 0 0 0 0000100 0 0 ' , ' 1 . 0 0 ' , ' 1 ' \n i should not get this...(357 273 277) what to do to e...

Yes my meta data is correct only...