Learn the reason and how to get to the bottom of the ORA-01756 error message in Oracle.
Description
When you come across an ORA-01756 error, the following error message will appear:
ORA-01756: quoted string not properly terminated
Cause
You tried to execute a assertion that contained a string that used to be not surrounded by using two single quotes. One of the charges was once entered barring the 2d accompanying quote.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Rewrite the declaration so that the string is surrounded through two single quotes.
For example, if you had tried to execute the following SELECT statement:
SELECT supplier_id, supplier_name
FROM suppliers
WHERE supplier_name = 'IBM;You would receive the following error message:
You can correct this SQL declaration through surrounding the string (ie: IBM) with two single rates as follows:
SELECT supplier_id, supplier_name
FROM suppliers
WHERE supplier_name = 'IBM';