Home » Fusion Middleware & Colab Suite » Business Intelligence » Bi Publisher before report
Bi Publisher before report [message #456409] Mon, 17 May 2010 15:45 Go to next message
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 #456445 is a reply to message #456409] Mon, 17 May 2010 22:40 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Quote:
defaultPackage="emptest"
Quote:
source="employee.beforeReport"()
Shouldn't it be source="emptest.beforeReport()"???

By
Vamsi
Re: Bi Publisher before report [message #456547 is a reply to message #456445] Tue, 18 May 2010 07:39 Go to previous messageGo to next message
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 #456577 is a reply to message #456547] Tue, 18 May 2010 09:36 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Do you have the package emptest and the function beforereport?
Quote:
Iam trying to write the before report trigger in the Datatemplate but getting the below error.
When are you getting the error?

By
Vamsi
Re: Bi Publisher before report [message #470074 is a reply to message #456577] Sat, 07 August 2010 23:43 Go to previous message
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

Previous Topic: Newbie: Need to extract all information on dashboard
Next Topic: XML Publisher Help
Goto Forum:
  


Current Time: Thu Jan 21 01:34:37 CST 2021