Error when generated Report/Sub-report ( ORA-06561: given statement is not...

A pure PL/SQL reporting engine (transforms jrxml to PDF)

Brought to you by: aweiden

Error when generated Report/Sub-report ( ORA-06561: given statement is not supported by package DBMS_SQL )

Forum: General Discussion

Creator: dat le tan

Created: 2018-02-01

Updated: 2018-02-02

dat le tan - 2018-02-01

Hello teams,
I am new in apex oracle and JRXML2PDF.
At first, I would like to say thanks for your solution.
As your replied via many topics about sub report, I tried and faced with error :
"ORA-06561: given statement is not supported by package DBMS_SQL".

My report included 2 part : report and sub-report ( only 1 static label not query ) which has been coppied xml content from IReport and created report name in table JRXML_REPORT_DEFINITIONS .

I guesed that the problem coming when generated sub-report from xml.

Please help me to check this matter .

Thanks

Last edit: dat le tan 2018-02-01

JRXML_REPORT_DEFINITIONS.png

PKN.jrxml

report1.jrxml

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Andreas Weiden - 2018-02-01
  
  Hi,
  
  the problem is that your subreport doesn't contain any valid query.
  
  Regards,
  Andreas
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - dat le tan - 2018-02-02
    
    It's working perfect. Thanks.
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.