Hi Teoh Ming Sui,
If you want to perform ‘Insert’, Please use “Execute Statement” JavaAction.
The Execute statement action works internally in the same manner as the Execute query action. However, it is used for INSERT
, UPDATE
, DELETE
, STORED PROCEDURE
, or DDL
statements.
Return value for Execute statement is an integer value, which usually represents the amount of affected rows.