Skip Headers
Oracle® Fusion Middleware Idoc Script Reference Guide
11g Release 1 (11.1.1)

Part Number E10726-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to current chapter
Go to next page
View PDF


This function loads a dynamicdata table into a result set. This function is similar to ddLoadResultSet except that it only loads those rows whose values for indexColumn match indexValue. The comparisons made on this column are case-insensitive.

Type and Usage


The following table lists parameters for the function.

Parameters Description
dataTableName The name of the dynamicdata table to load.
idocTableName The name of the result set into which the dynamicdata table should be loaded.
indexColumn The name of an indexed column in the dynamicdata table.
indexValue The value to use to select a section of the original table. This value will be checked in a case-insensitive manner against the indexColumn in each row. If it matches, that row is loaded into the result set; otherwise it is skipped.
mappingTableName The name of a dynamicdata table used to rename the columns of the final result set. The renaming is done by mapping the column names in the specified mapping table to the values of the first row in the same table. This is done exactly the same in ddLoadResultSet.


If the dynamicdata table is successfully loaded, it returns True.


<@dynamicdata MyDataTable@><?commatable indexedColumns="fieldA"?>fieldA, fieldB, fieldC1,      2,       34,      5,       61,      3,       9<@end@>

<$exec ddLoadIndexedColumnResultSet("MyDataTable", "MyResultSet", "fieldA", "1")$><$exec rsFirst("MyResultSet")$><$foo = MyResultSet.fieldB$>    [[% (foo == '2') %]]<$exec rsNext("MyResultSet")$><$bar = MyResultSet.fieldC$>    [[% (bar == '9') %]]

See Also