Oracle Databse : 10g
I have the following function which gives me error when i am compiling
function xmlgen_escaped_string(a_string in varchar2) return varchar2 is
l_result varchar2(4000) := a_string;
l_sql varchar2(32767) := q'!select q'[!'||a_string||q'!]' as "!'||a_string||'" from dual';
begin
if a_string is not null then
select extract(
dbms_xmlgen.getxmltype(l_sql),'/*/*/*'
).getRootElement()
into l_result
from dual;
end if;
return l_result;
end;
Error: [Error] ORA-00904 (620: 21): PL/SQL: ORA-00904: : invalid identifier