Never name it.

Get JVM Property CREATE OR REPLACE FUNCTION getJava_property ( jProperty IN VARCHAR2) RETURN VARCHAR2 IS LANGUAGE JAVA name 'java.lang.System.getProperty(java.lang.String) return java.lang.String'; SELECT getjava_property('java.version') FROM dual;

How to sum up , row and column in the template ?

How to handle blank page, if no data in the xml.. Put a section break and add the code like following <?if@section:count(/DATA/LIST_INVOICES/INVOICES) = 0?>No invoices for this criteria<?end if?> You can handle the no data found like this.

http://forums.oracle.com/forums/thread.jspa?messageID=3344649 In order to get the all months,the for-each should have been put on the whole xml, rather than , the current group. the current group might be missing some month value in the xml.

http://forums.oracle.com/forums/thread.jspa?messageID=3343920 http://forums.oracle.com/forums/thread.jspa?threadID=871513 This is little tricky, but do able.