BI Publisher (MOSC)

MOSC Banner

lexical parameter support

edited Jun 7, 2012 6:41AM in BI Publisher (MOSC) 7 comments
Hello ,
If i have a data template like the below using lexical parameters :

  <?xml version="1.0" encoding="UTF-8" ?>
- <dataTemplate name="XXBUDVER" description="Provides an audit trail of changes to a budget from one version to another" defaultPackage="custpa_budget_versions" version="1.0">
- <parameters>
  ...
  </parameters>
- <lexicals>
  <lexical dataType="varchar2" name="PWHERECLAUSE" />
  </lexicals>
- <dataquery>
- <sqlStatement name="Q_BUDGET_VERSIONS">
- <![CDATA[ SELECT
...
... FROM xxgnl_budget_versions_v WHERE 1 = 1 AND ...
...
 and &PWHERECLAUSE ...
  ]]>
  </sqlStatement>
  </dataquery>
  <dataTrigger name="beforeReport" source="custpa_budget_versions.beforeReportTrigger" />
- <datastructure>
- <group name="G_PARAMETERS" source="Q_BUDGET_VERSIONS">
  <
  </group>
  </group>
  </datastructure>
  </dataTemplate>

Current version is :
5903765 21-JAN-2008 22:32:22 11i.ATG_PF.H.RUP6 11i
6008417 22-JAN-2008 00:55:12 AOL USER RESPONSIBILITY SECURITY FIXES 2b 11i

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center