I’m using the Database writer node to write to an Oracle database and I am getting a database error. I have a column that I have created where the value is actual a function call:
String guid = “LOWER(REGEXP_REPLACE(sys_guid(),’(…)(…)(…)(…)(…)’,’\1-\2-\3-\4-\5’))”;
I have this column designated as a string. The problem is the Database writer seems to be treating this column as an actual string and I think enclosing the value with single quotes. This is a primary key, I get an error when the second row gets inserted with a primary key violation. This is not what I want. I tried changing the type to numeric hoping the column value would be entered as is without quotes.
I have generated a sql insert with this value and the insert statement will work fine. Is there anyway to let the Writer know not to enclose the value with single quotes (if that is what is happening)?