Skip to Content
0
Former Member
Sep 10, 2007 at 07:05 AM

UDF: Mapping query-------Urgent

14 Views

hi...

I m doing a scenario from File to JDBC. I have the following requirement.

Source:

Field1

Field2

On the target side i should be able to insert into database such that in column FIELD i get:

Field1

Field2

This new line can be incorporated by concatenating Field1 with '|| chr(10) ||'

-


which is used in Oracle for inserting a new line.

But now i am facing a problem. The database is treating '|| chr(10) ||' as a string and instead of getting Field2 on a new line i am getting the inserted row as:

Field1 || chr(10) || Field2.

Please help me resolve this.