Before report errors
Hello,
I created a before report trigger in my custom package and calling that from my data definition. I am getting the following errors:
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.xxxxx module: xxxxxx+---------------------------------------------------------------------------+Current system time is 15-JUN-2012 17:16:37+---------------------------------------------------------------------------+XDO Data Engine Version No: 5.6.3Resp: 20639Org ID : 101Request ID: 884621All Parameters: P_STORE_NO=4002Data Template Code: xxxxxxData Template Application Short Name: SQLAPDebug Flag: N{P_STORE_NO=4002}Calling XDO Data Engine...[061512_051648479][][STATEMENT] Start process Data[061512_051648480][][STATEMENT] Process Data ...[061512_051648481][][STATEMENT] Executing data triggers...[061512_051648481][][STATEMENT] BEGINCT_CTLEAB_REPORT_PVT.P_STORE_NO := :P_STORE_NO ;:XDO_OUT_PARAMETER := 1; END;[061512_051648482][][STATEMENT] 1:4002 :[061512_051648498][][EXCEPTION] SQLException encounter while executing data trigger....java.sql.SQLException: ORA-06550: line 2, column 22:PLS-00302: component 'P_STORE_NO' must be declaredORA-06550: line 2, column 1:PL/SQL: Statement ignoredat 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:4710)at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:262)at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)at0