BI Publisher (MOSC)

MOSC Banner

Access columns in Non-Standard SQL

edited Sep 22, 2015 10:03AM in BI Publisher (MOSC) 9 commentsAnswered

Hello,

I am calling a SQL Server stored procedure as my datasource using the "Non-Standard SQL" option.

This produces an XML dataset as follows:

<?xml version="1.0" encoding="UTF-8"?>
<!--Generated by Oracle BI Publisher 11.1.1.7.141014 -Dataengine, datamodel:_so_dk_TEST_AbaSec_Test_Abasec_ScheduleTrigger_Test_xdm -->
<ROWSET>
  <G_1>
  <recordtype>H</recordtype>
  <clientplaceofbooking>FRA</clientplaceofbooking>
  <creditdebitcode>D</creditdebitcode>
  <tottaxamount>28,12</tottaxamount>
  </G_1>
</ROWSET>

However, on the BI Publisher screen I see it as a global level function as in the screenshot below. I would like to access the column variables in my AfterData trigger. Is there any way of achieving this?

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