XML Parsing failed for special characters -

XML Parsing failed for special characters -

i using below script parse ';' separated inputs different rows: (select extract (value (d), '//row/text()').getstringval () (select xmltype (''|| replace ('valueof(nq_session.p_acct)', ';', '')|| '') xmlval dual) x, table (xmlsequence (extract (x.xmlval, '/rows/row'))) d)

this code fails when comes across input p_acct '&' value, i.e. if p_acct 'at&t'. how can create sure strings processed inot different rows.

thanks, yada.

you need replace special characters

in illustration at&t needs at%26t

code

replace(string ‘&’, ‘%26′)

xml xml-parsing obiee