This content has been marked as final. Show 12 replies
we need more details, possibly access to the workspace to troubleshoot that.
*) Are you sure, the installation of the packages was successful? Perhaps something went wrong there.
*) Are you doing a redirection of sorts (owa_util.redirect_url or something)? What page are you trying to load?
Without having access to the application it is really hard to troubleshoot. I don't think it is a resource restriction. The APEX team uses dbms_resource_manager rules, but the rendering and display of the error message returns too fast for that.
Or are you using recursion and you quickly hit a too deep level?
i've shrinked the code to just contain the problem and the result is quite strange. The remaining code does nothing more but taking an xmltype and splitting in down into a record-structure by using some cursors. I even hardcoded the used XML in the package instead of reading it from a table.
There's one piece where i parse the different regions of the JRXML with the following cursor definition used
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 run the following code from SQL Workshop, it sometimes succeeds with a "Statement processed" and sometimes fails with a "Page not found". (The "sometimes" thing is what makes me nervous, and that there is no oracle-error but simply a Page not found which may be something like "No more data to read from socket" in local development tools). It would be interesting to know if there is some error in the alert.log.
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 '.' );
Even if its unlikely, either i used an undocumented feature which doesn't work correctly, or this maybe is a bug.
If you like to have a look at it yourself, i opened the workspace
I'll see if i can bypass this error by some recoding.
Edited by: Andreas Weiden on 12.07.2012 22:10
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:
But the blog post says sessions are killed only after 1800 seconds, which means your process has to be running for a looong time before being affected by this....