Whether we can achieve such a node, and its function is called with parameters of the storage process
---------------------------------------------------
Grf:
DB_INPUT_TABLE -> DB_CALL_PROCEDURE
Or
DELIMITED_DATA_READER -> DB_CALL_PROCEDURE
---------------------------------------------------
table structure:
create table hwtest1 (c1 numeric(10,2),c2 varchar2(30),c3 date);
-------------------------------------------------------------
procedure content:
create or replace procedure p_hw1(args1 in number, args2 in varchar2,args3 in date,re1 out varchar2) is
c_1 numeric(10,2);
c_2 varchar2(30);
c_3 date;
begin
c_1 := args1;
c_2 := args2;
c_3 := args3;
begin
insert into hwtest1 (c1,c2,c3) values(c_1,c_2,c_3);
commit;
re1:='Success';
Exception WHEN OTHERS Then
rollback;
re1 := 'Failed';
end;
end p_hw1;
---------------------------------------------------
Grf:
DB_INPUT_TABLE -> DB_CALL_PROCEDURE
Or
DELIMITED_DATA_READER -> DB_CALL_PROCEDURE
---------------------------------------------------
table structure:
create table hwtest1 (c1 numeric(10,2),c2 varchar2(30),c3 date);
-------------------------------------------------------------
procedure content:
create or replace procedure p_hw1(args1 in number, args2 in varchar2,args3 in date,re1 out varchar2) is
c_1 numeric(10,2);
c_2 varchar2(30);
c_3 date;
begin
c_1 := args1;
c_2 := args2;
c_3 := args3;
begin
insert into hwtest1 (c1,c2,c3) values(c_1,c_2,c_3);
commit;
re1:='Success';
Exception WHEN OTHERS Then
rollback;
re1 := 'Failed';
end;
end p_hw1;
-
Thank you for your response, I think, this node will be responsible only for the importation of the record sent to the database server storage process, and can return to the stored procedure in the definition of parameters.
Each node can be set up through the corresponding record of success and the failure of the information recorded information output to a designated location, this should belong to log module functions.
Successful track record is based on the number of users in the storage process is set up transactions, and if the settings and the affairs of the rollback transactions, the records of the number of so successful is 0.
(MaxErrors attributes) in the process of storage services with high-level should be as DB_OUTPUT_TABLE nodes in the errorAction attribute priority.
Output port storage output value of the return process.
Example:
<Node id="DB_CALL_PROCEDURE_0" type="DB_CALL_PROCEDURE" errorAction="ROLLBACK" fieldMap="cloverField=storageProcessArgs" />
Please sign in to leave a comment.
Comments 4