plsql - How to handle Special char in xml file while using DBMS_SQL.EXECUTE ? in dynamic query -
when pass collection record of cursor "c" , execute using dbms_sql.execute xml file, have using special character "&" etc... other non spl-char record has been executed dynamic query value using special char throwing error - ora-31011: xml parsing failed. here code
c := dbms_sql.open_cursor; -- parse sql statement dbms_sql.parse(c, p_sql(i), dbms_sql.native); -- start execution of sql statement d := dbms_sql.execute(c);
Comments
Post a Comment