The i_vcBaseNode is passed from outside the procedure and can be one of the valid jrxml-regions, e.g. 'detail'
vcText VARCHAR2(2000):='/' || i_vcBasenode || '/band'; CURSOR crBand IS SELECT BAND FROM XMLTABLE(vcText PASSING i_oRegion COLUMNS BAND XMLTYPE PATH '.' );
When i rewrite the code to use a static string in the XMLTABLE like
DECLARE lParams PK_JRXML2PDF_REPGEN.tParamList; bl BLOB; BEGIN bl :=PK_JRXML2PDF_REPGEN.FK_RUN(i_vcName =>'mini', i_lParams=>lParams); END;
the error vanishes. But that means a partial rewrite of the package because i have to multiply my cursors.
CURSOR crBand IS SELECT BAND FROM XMLTABLE('/detail/band' PASSING i_oRegion COLUMNS BAND XMLTYPE PATH '.' );
My only idea is that there is some kind of resource-restriction which simply "halts" the execution of the PL/SQl-program. Is that the case?Actually, there is a Resource Manager plan in effect on apex.oracle.com, as described here: