Versions Compared

Old Version 2

changes.mady.by.user Chee Hove Teng

Saved on

compared with

New Version Current

changes.mady.by.user Chee Hove Teng

Saved on

Key

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

...

Code Block
languagetext
table tableCreateShared 
    ( string profileName 
	  @Deprecated boolean autoCommitdisableCommit )


Parameters:

Returned Value

Description

profileName

Name of the Shared Table profile you want to use.autoCommit

disableCommit

(Deprecated since PE 4.3)

An optional parameter to enable disable the commit statement to from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in no the commit statement to be performed at the end of every SQL transaction for this particular function. By default, will have the autoCommit disableCommit set to true unless otherwise changed via this parameter.

Info

It should be noted that on recent Oracle versions, the DBLink SQL transaction behavior 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 workflows.

...

Code Block
languagetext
table tableRefreshShared 
    ( string profileName 
	  @Deprecated boolean autoCommitdisableCommit )


Parameters:

Returned Value

Description

profileName

Name of the Shared Table profile you want to refresh data for.autoCommit

disableCommit

(Deprecated since PE 4.3)

An optional parameter to enable disable the commit statement to 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 autoCommit disableCommit set to true unless otherwise changed via this parameter.

Info

It should be noted that on recent Oracle versions, the DBLink SQL transaction behavior 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.

...