Any advice or direction would be helpful.
Thank you in advance.
-abe
Question
Error Handling for a Writer to Oracle
Does FME Workbench 2013 have the ability to handle oracle exceptions without terminating the entire transformation? Currently, the transformation encounters an oracle exception (on insert) and stops. I'd like to log that and continue with the loading from a geodatabase file to the table with a spatial column.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
Hi,
You can try to test for the features that result in an exception before writing and write them to a FFS, what kind of error does oracle return?
Hello.
Here is a snipet from the log:
Oracle Writer: Translation aborted -- rerun specifying "ORACLE8I_2_START_TRANSACTION 108"
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
ORA-00001: unique constraint (PK_SOMENAME) violated
When I disable the constraint, I can load all of the data and this goes without saying. So, instead of alter base tables and constraints I was curious to know if the workspace could be setup to allow errors somehow. I'm a database guy, and very new to FME.
Hi,
unfortunately, an Oracle exception will terminate the entire translation.
You can fix the error and restart it at the failing transaction (as the log will tell you), though.
David
+2- Contributor
Hi all,
Did you get anything new on this subject since 2013?
I tried an INSERT within a single statement (begin...end;) but when the rollback is done by ORACLE, my translation terminates and I have to read the log to understand what's going on.
I there a way to declare a variable and return it to FME?
DECLARE my_variable VARCHAR(255); BEGIN INSERT ... EXCEPTION WHEN OTHERS THEN my_variable := '[' ||SQLCODE||'] '||SQLERRM; END;
Thanks for your help.
.JP