Bi Publisher before report [message #456409] |
Mon, 17 May 2010 15:45 |
chandra_mkh
Messages: 13 Registered: May 2010 Location: india
|
Junior Member |
|
|
Hi,
Iam trying to write the before report trigger in the Datatemplate but getting the below error. any suggestion please.
ORA-06550: line 4, column 20:
PLS-00302: component 'BEFOREREPORT' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
this is the code in the datatemplate.
<dataTemplate dataSourceRef="demo" name="emptest" defaultPackage="emptest">
<properties>
<property name="xml_tag_case" value="upper"/>
<property name="include_parameters" value="false"/>
</properties>
<parameters>
<parameter name="DEPTPARAM" dataType="character" defaultValue=""/>
</parameters>
<lexicals>
</lexicals>
<dataQuery>
<sqlStatement name="Q_1">
<![CDATA[
select *
from emp where deptno=nvl(:deptparam,deptno)]]>
</sqlStatement>
</dataQuery>
<dataTrigger name="beforeReport" source="employee.beforeReport()"/>
<dataTrigger name="beforeReport" source="employee.beforeReport(:Parameter)"/>
<dataStructure>
<group name="G_EMPNO" dataType="varchar2" source="Q_1">
<element name="EMPNO" dataType="number" value="EMPNO"/>
<element name="ENAME" dataType="varchar2" value="ENAME"/>
<element name="JOB" dataType="varchar2" value="JOB"/>
<element name="MGR" dataType="number" value="MGR"/>
<element name="HIREDATE" dataType="date" value="HIREDATE"/>
<element name="SAL" dataType="number" value="SAL"/>
<element name="COMM" dataType="number" value="COMM"/>
<element name="DEPTNO" dataType="number" value="DEPTNO"/>
</group>
</dataStructure>
</dataTemplate>
|
|
|
|
Re: Bi Publisher before report [message #456547 is a reply to message #456445] |
Tue, 18 May 2010 07:39 |
chandra_mkh
Messages: 13 Registered: May 2010 Location: india
|
Junior Member |
|
|
Sorry that is typo mistake I tried with emptest.beforereport() only. but still iam getting the error.
ORA-06550: line 4, column 19:
PLS-00302: component 'BEFOREREPORT' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
<dataTrigger name="beforeReport" source="emptest.beforeReport()"/>
<dataTrigger name="beforeReport" source="emptest.beforeReport(:Parameter)"/>
|
|
|
|
Re: Bi Publisher before report [message #470074 is a reply to message #456577] |
Sat, 07 August 2010 23:43 |
AshishRaj
Messages: 12 Registered: August 2010
|
Junior Member |
|
|
Why do you have two instace of dataTrigger.
<dataTrigger name="beforeReport" source="emptest.beforeReport"/>
<dataTrigger name="beforeReport" source="emptest.beforeReport(:Parameter)"/>
Please check the beforeReport function definition in your defaultPackage and have the correct one. You don't need to pass any parameter in before report trigger as all the parameter automatically set. Function definition beforeReport() should be fine.
[Updated on: Sat, 07 August 2010 23:44] Report message to a moderator
|
|
|