Skip Headers
Oracle® Fusion Middleware Idoc Script Reference Guide
11g Release 1 (11.1.1)
E10726-01
  Go To Documentation Library
Library
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

ddAppendResultSet

This function loads a dynamicdata table into a result set. It is very similar to ddLoadResultSet. The main difference is that if the Idoc Script result set already exists, the new result set created from the dynamicdata table is appended to it. Any fields found in the dynamicdata table, but not in the target result set, are automatically added.

Type and Usage

Parameters

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 appended.
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.

Output

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

Example

<@dynamicdata MyDataTable@>field1, field2, field3a,      b,       cd,      e,       f<@end@>


<$exec rsCreateResultSet("MyResultSet", "field1,field2")$><$exec rsAppendNewRow("MyResultSet")$><$MyResultSet.field1 = "first value"$><$MyResultSet.field2 = "second value"$><$exec ddAppendResultSet("MyDataTable", "MyResultSet")$><$exec rsFirst("MyResultSet")$><$foo = MyResultSet.field1$>    [[% (foo == 'first value') %]]<$exec rsNext("MyResultSet")$><$bar = MyResultSet.field3$>    [[% (bar == 'c') %]]

See Also