Jump to content

Error:net.sf.jasperreports.engine,JRException:Error executing SQL statement for :data


tribhuwan.kushwaha

Recommended Posts

I am generating Report with using Oracle StoreProcedure and for that i make report  query language plsql also and write following query

{CALL CPR_GET_TAXPAYER_INFO($P{p_accttype},$P{ORACLE_REF_CURSOR},$P{p_with_bus},$P{p_lang})}

But when i Preview data There is Error  message Error:net.sf.jasperreports.engine,JRException:Error executing SQL statement for :data.

When i Preview Report after inserting parameter value there is the following Error ,

 Compiling to file... D:JasperReportsreport1.jasper Compilation running time: 192!


 Filling report...  Locale: English (United States)  Time zone: Default Error filling print... Error executing SQL statement for : report1
java.sql.SQLException: ORA-12705: Cannot access NLS data files or invalid environment specified
 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) 
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) 
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) 
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) 
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) 
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) 
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) 
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882) 
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847) 
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301) 
    at com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:149) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:889) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report1 
    at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1087) 
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:668) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877) 
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) 
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) 
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) 
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) 
    at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) 
    at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) 
    at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Caused by: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CPR_GET_TAXPAYER_INFO'
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CPR_GET_TAXPAYER_INFO'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) 
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) 
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) 
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) 
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) 
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) 
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202) 
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005) 
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307) 
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) 
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550) 
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4693) 
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1086) 
    at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:128) 
    ... 12 more 

Print not filled. Try to use an EmptyDataSource...

What will be the Solution here ,plese help with good answer.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...