Clarification required in File to DB scenario

[Former Member]

Hi all,

I have a requirement to insert flat file records to a Oracle database.

Few fields in the database are of type nchar/nvarchar.Is there any special transformation required in PI for these fields, as my records are not getting inserted into DB when i pass a char value for these.If i pass numbers for the same,the records are getting inserted.As of now the datatype of these fields in PI is string.

Please guide me on this.

Thanks,

Sowmya

[Former Member]

Hi,

It will not allow single Character value.Multiple character value or numbers it will allow.

Regards,

Prakasu.M

[former_member206760]

Hi sowmya,

is this problem resolved?

if yes , pls state how ....

[former_member192295]

Hi,

I think data type should be same in DB & PI, meanwhile valiables sequence in PI should be same as DB sequence names.

Find below link for more help on configuration

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

[former_member206760]

try using one of the following datatypes in the oracle table BLOB, CLOB, NCLOB

do not use nchar/nvarchar