Insert Into Statement causes ORA-01756: quoted string not properly terminated

Question

Environment: DevArt Drivers for Oracle .NET 4.5

I'm trying to execute the following statement:

INSERT INTO T_CUSTOMERS_T
  ("ID",        "NAME1",            "NAME2",   "NAME",          "STREET",
   "POSTAL",    "CITY",             "COUNTRY", "TEL",           "MAIL",
   "STATE",     "STATE_EX",         "REF") 
VALUES
  (N'23frRRrg', N'Peter',           N'Hansel',  N'Peter Hansel', N'Flowerpowerstreet 5',
   N'88558',    N'New York',        N'US',      N'1801810',      N'[email protected]',
   N'VALID',    N'Record is valid', NULL);

I got the following exception from the devart driver:

Type: OracleException
Message: ORA-01756: quoted string not properly terminated

Call Stack:    at Devart.Data.Oracle.ax.c(Int32 A_0)
   at Devart.Data.Oracle.b9.a(String A_0)
   at Devart.Data.Oracle.OracleCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
   at DataConnection.AddRecords(TableMetadata TableStructure, Dictionary`2[] Records)

EDIT:

I executed the statement with the odbc oracle driver and it works fine. I'll update the devart driver tomorrow and see if that solves the problem.

Answer 1

Based on the DevArt documentation OracleDataAdapter

INSERT INTO myTable(col1,col2col5,col7) VALUES ('data1','data2','data3',NULL)