Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ignore error during file to db load

User_F2HJQAug 17 2022

Hi All,
We have a requirement in our project for file to DB interface , while loading from source table to target table.
From source table in one of the field we are getting ||| as column separatore instead of || for one of the column , so it is throwing end be greater than begin error. When i run the interface it is getting errored out, but we dont want the execution to be stopped at that point.
We want execution to be continued and interface should not insert errored records which does not satisfy the format and it should insert all other proper records.
I have used incremental update and i enabled flow control and static control options but stil It is erroring out.
could you please provide any suggestion on how to ignore the errors.

Comments

james_sutherland
How have you tried to call this and what result did you get?

I assume you are using the cursored output parameter support in TopLink's StoredProcedureCall. When this is used the cursor is treated as the result set and the returned rows will come from the cursor. The additional output parameters can be accessed through a SessionEventListener using the outputParametersDetected SessionEvent.
380279
Thanks!

The outputParametersDetected SessionEvent did the trick! Thanks a lot!

-bjorn
487035
Hi there,
I am new to toplink and am calling a procedure which returns me 2 resultsets. I am using the code:

call = new StoredProcedureCall();
call.setProcedureName("pGetPearDetailForSearch");
call.addNamedArgumentValue("PearIds",listConcatenatedPearIds);
Vector searchDetails = uow.executeSelectingCall(call);

This way i am not getting the vector for the 2nd resultset which gets me a 2nd set of results.
What code do i have write to traverse the 2nd resultset being returned from the Procedure.

regards
Kamal
zb
Check out this thread. The code is at the bottom.
Zev.

1295450
587238
Someone have a working example how to call a stored procedure with multiple output parameters, and of course read them?
Using outputParametersDetected?
Thanx a lot.
1 - 5

Post Details

Added on Aug 17 2022
#business-intelligence-applications, #data-integrator, #system-management-and-integration
0 comments
117 views