Hi.
I am using orchestration method to debatch incomming msg. Then mapping
single msg with orachle adapter schema to insert into table using oracle
package.
I am having issue in inserting in to oracle table.
If i have 4 records in the input file, only one record will be insert into
table.
I tested with 124 records, only 106 records has been inserted. Same time if
i send the out put to some folder, i am getting 124 xml out puts. It looks
like debatching and mapping works fine however I it is not inserting into
table correctly.
I am using a package something like:

CREATE OR REPLACE PACKAGE Order_Pac AS
PROCEDURE order_Proc(nID IN Varchar2, nName IN Varchar2);
END Order_Pac

CREATE OR REPLACE PACKAGE BODY Order_Pac AS
PROCEDURE order_Proc(nID IN Varchar2, nName IN Varchar2)
IS
dDate Date;
BEGIN
insert into Order_Tab (nID,nName,dDate) values(nID,nName,dDate)
COMMIT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
ROLLBACK;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
ROLLBACK;
END Order_Proc;
END Order_Pac;
/

How can i solve this issue?

Thank you in adavance,
Siva

--
Thank you,

Siva

[ Post a follow-up to this message ]