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.
In data template we can call as below
e.g.
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.