Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For further information about memory allocation in, see the System Administration Guide.

...

Returned ValueDescription

profileName

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 is set to true unless otherwise changed via this parameter.

Info

It should be noted that on recent Oracle versions, the DBLink SQL transaction behaviour has changed, where every single SQL statement for remote database transaction requires a commit or rollback statement in order to close a connection.


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 ValueDescription

profileName

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 is set to true unless otherwise changed via this parameter.

Info

It should be noted that on recent Oracle versions, the DBLink SQL transaction behaviour has changed, where every single SQL statement for remote database transaction requires a commit or rollback statement in order to close a connection.


Returns

A refreshed shared table.

...