Q)Is it possible to call Calling PL/SQL procedure/function from a BI Reports Template ?
In data template we can call as below
e.g.
<dataTrigger name="beforeReport" source="employee.beforeReport()"/>
<dataTrigger name="beforeReport"source="employee.beforeReport(:Parameter)"/>
In data template we can call as below
e.g.
<dataTrigger name="beforeReport" source="employee.beforeReport()"/>
<dataTrigger name="beforeReport"source="employee.beforeReport(:Parameter)"/>
but in case of BI report templates we can't call why because
as reason is no way to call a PL/SQL from the Layout Template and such functionality doesn't exist .
why because as there is no database connection when processing layouts, so no you cannot call a pl/sql function.
