DevOps, CI/CD and Automation

Hi

Is there anybody who suceeded in building up an xml component based on a query outside or inside a stored procedure?
Let's suppose I'd like to use a cursor in the <ORACLE> tag in order to select all elements from a table..
it seems like the reading loop is completely ignored in the xml component in Portal: by printing a hand-made raw like: htp.p('<NAME>|| CURSOR.NAME_ELEMENT ||</NAME>'); in a loop I get a single raw in the final table:
'||cursor.name_element||'

I also tried to make the selection inside a stored procedure and tried to run this from the xml component in the oracle section: I got no error, but still nothing is displayed.
Furthermore I'm not able to call an XML URL: I have this string displayed:

>>
java.security.AccessControlException: the Permission (java.util.PropertyPermission http.proxySet write) has not been granted by dbms_java.grant_permission to SchemaProtectionDomain(PORTAL30|PolicyTableProxy(PORTAL30)) at java.security.AccessControlContext.checkPermission(AccessControlContext.java) at java.security.AccessController.checkPermission(AccessController.java) at java.lang.SecurityManager.checkPermission(SecurityManager.java) at oracle.aurora.rdbms.SecurityManagerImpl.checkPermission(SecurityManagerImpl.java) at java.lang.System.setProperty(System.java) at oracle.webdb.xmlcomp.XMLTransDoc.Transform(XMLTransDoc.java:48)

>>

Please help