Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parsing Error in Code Outline?

User_4AL7NJun 22 2022

The following function compiles and works as expected:
function F_GetXQuerResult2(
P_XmlText in clob
, P_XQueryExpr in varchar2
) return xmltype as
L_r xmltype;
L_x xmltype := xmltype.CreateXml(P_XmlText);
begin
select XMLQUERY( P_XQueryExpr passing L_x returning content ) into L_r from dual;
return L_r;
end F_GetXQuerResult2;
image.pngimage.png
But I get a "syntax error" (not from compile!) and code outline is not displayed

Comments

Post Details

Added on Jun 22 2022
1 comment
134 views