This content has been marked as final. Show 4 replies
What is your db version?
in 11gr2 you can do:
SQL> select x, dump (x) dump_x from xmltable (('concat("abc", "'||chr(1)|| '")') columns x varchar2(5) path '.') / X DUMP_X ----- ------------------------- abc Typ=1 Len=4: 97,98,99,1
Would like to give more information on the requirement I have:
I receive text data from an I/P source that contains fields delimited with hexadecimal 01 value(i.e.\x01).This hexadecimal delimiter looks like a square bracket ()in the incoming text file but is actually a hexadecimal 01.The last field in the file is not followed by a delimiter.
I have written a MFL that uses hexadecimal 01(i.e. \x01) as the delimiter value.The Proxy Service reads the incoming text file .In the message flow,I parse the file content using the MFL I have created.
Since the last field in the file is not followed by hex-01 delimiter,I am trying to explicitly concatenate hex-01 to the last field before using MFL transform otherwise my XQuery will fail.
I don't know how to concatenate hexadecimal to the last field.I tried several ways but the data gets concatenated as text and not as hex delimiter.
Can you please help me with the statement that will concatenate hex-01 delimiter value to the text data so that my Query does not fail.
I know this is an old post but for others who are searching for the answer this worked for me:
fn:concat( 'abcd', '' )