Skip to main content
  • EN

I'm using a SqlExecutor deleting some data in a Oracle database.

FME_SQL_DELIMITER ;
--feuille 1
DELETE FROM G_ADT_AGRI.EXP_INVEST WHERE OBJECTID = @Value(OBJECTID);
/*
--feuille 2
DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = @Value(OBJECTID);*/

As you can see I commented the "feuille2" part. But I have this error message : 

An error occurred while accessing a table result for feature type `QueryFactory_SQLExecute'; message was `Execution of statement `/*

--feuille 2

DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = 699' did not succeed; error was `ORA-01742: comment not terminated properly

Although I use the right comment syntax. What did I miss?

The SQLExecutor (or the Oracle driver, I'm not sure) doesn't like comments. Remove the comments and it should work.

The SQLExecutor (or the Oracle driver, I'm not sure) doesn't like comments. Remove the comments and it should work.

Indeed if I remove the /*...*/, it's fine. Thanks.

It seems that is the Oracle driver because with a Postgresql database, it works.

Is that a known bug in Safe?

Indeed if I remove the /*...*/, it's fine. Thanks.

It seems that is the Oracle driver because with a Postgresql database, it works.

Is that a known bug in Safe?

Not sure, but the issue has been mentioned here before.

Reply


Community Stats

30,102
Posts
114,268
Replies
37,736
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.