DevOps, CI/CD and Automation

Hi,

In an XQuery query is it posssible to call a function or procedure SQL (PL / SQL)?
Here is an example of what I'd achieved :


SELECT PRD.XMLCOLUMN from
XMLTABLE('for $i in ora:view("P_iXXX")/ROW,
$j in ora:view("P_jXXX")/ROW,
where
($i/NSU_xxx = $j/NSU_xxx)
return
(
<NCL>
{
$i/NSU_xxx,
h3. CALL Function SQL ???? as sql_xxx
for $k in ora:view("P_kxxx")/ROW
$vk/COD_RMP_VPM = "PRD")
return()
}
</NCL>
)' COLUMNS "resultsqlfunction" INTEGER PATH 'xsql_xxx' "NSU_xxx" INTEGER PATH 'NSU_xxx',"XMLCOLUMN" XMLType PATH '.') as PRD;

Thank you in advance for your answers
François