...
For further information about memory allocation in, see the System Administration Guide.
...
Returned Value | Description | ||
---|---|---|---|
| Name of the Shared Table profile you want to use. | ||
disableCommit | An optional parameter to disable the commit statement from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in the commit statement to be performed at the end of every SQL transaction for this particular function. By default, will have the disableCommit set to true unless otherwise changed via this parameter.
| ||
Returns | A table containing the columns stated with the SQL query in the stated Shared Table profile, that can be shared by several workflow instances. |
...
Returned Value | Description | ||
---|---|---|---|
| Name of the Shared Table profile you want to refresh data for. | ||
disableCommit | An optional parameter to disable the commit statement from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in the commit statement to be performed at the end of every SQL transaction for this particular function. By default, will have the disableCommit set to true unless otherwise changed via this parameter.
| ||
Returns | A refreshed shared table. |
...
The Oracle JDBC driver includes a feature built that allows you to set the number of rows that are prefetched while the full result set is being formulated. At the time of writing, the default number of prefetched rows is 10. You can increase this value by setting the Execution Context property oracle.jdbc.defaultRowPrefetch
in the relevant pico configuration file.
Scroll ignore | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
Scroll pagebreak |
---|