Insert data in Oracle, db-schema contains "-"

Anonymous — Fri, 30 Oct 2015 14:35:01 GMT

Hi,
I'm trying to do a fairly simple ETL job, but the problem is that the table I want to write to is stored in an Oracle schema which contains a "-": "DB-SCHEMA" (example).

Now the tOracleOutput generates this:
INSERT INTO DB-SCHEMA.TEST (TESTCOLUMN) VALUES ('record1')
which causes an error (ORA-00926. 00000 - "missing VALUES keyword")
Because the correct statement would be this:
INSERT INTO "DB-SCHEMA".TEST (TESTCOLUMN) VALUES ('record1')
does anybody know how I can either make sure there are quotes around the schema name, or the statement is generated without the schema prefix?

thanks in advance!

Re: Insert data in Oracle, db-schema contains "-"

Anonymous — Sat, 31 Oct 2015 10:46:03 GMT

Good day
How execute your sentence?
try build a expression using escape characters. For example :

"INSERT INTO \"" + row1.schema + "\".TEST (TESTCOLUMN) VALUES ('" + row1.value + "')"

Best regards,

Alfonso Borre
skype: alfonso.borre
aborresarmiento@yahoo.es

topic Insert data in Oracle, db-schema contains "-" in Talend Studio

Insert data in Oracle, db-schema contains "-"

Re: Insert data in Oracle, db-schema contains "-"