Also, you must provide a value for each column. That way you can avoid these errors because no individual string literal needs to be very long. In first example it returned error and in second case it does not because to include single quote(‘) another single quote (‘) is used which is termed as escape character. Please try writing the long string as multiple strings using your available concatenation function (sometimes available as CONCAT) or concatenation operator (SQL-92 standard, SQL Server +, etc.). I got the following exception from the devart driver: Type: OracleException Message: ORA-01756: quoted string not properly terminated Call Stack: at .c (Int32 A0) at 9.a (String A0) at .InternalPrepare (Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords) at. If one single quote is used, Oracle will interpret it as the ending string delimiter and fail with ORA-1756.Ĭreate or replace procedure my_proc(var in varchar2)as please let me know the issue with following script (sql,oracle 10g) 1 DECLARE colname AS NVARCHAR (50) 2 DECLARE tablename AS NVARCHAR (500) 3 DEClARE query AS NVARCHAR (500) 4 SET colname 'select wkunits1 from cntslsdm.fctsalessummary' 5 SET tablename 'SELECT tablename from dmi. The first single quote is an escape character which signals that a special character is following – here another single quote. ORA-01756: quoted string not properly terminated. ERROR: ORA-01756: quoted string not properly terminated 1 row created. If single quote is one of the characters inside the string, then it should be represented by two single quotes (”). In Oracle, single quote is the string delimiter for all string data types.

ORA-01756: quoted string not properly terminated

Single quote within a string data type like CHAR, VARCHAR2, NVARCHAR etc. For Egs: string nam'Frank D'Souza' namnam.Replace (''','''') now the inserted value would be. ORA-01756: quoted string not properly terminated Even I had founded the solution in the same way, when the Value is been inserted into the database, I just used the inbuild function Replace available in asp.net.

Quoted string not properly terminated