ORA-01756:quoted string not properly terminated
groxyJul 23 2010 — edited Jul 23 2010Dear experts,
We are working on Oracle 11.2 on Linux 64-bit
I am trying to execute the following sql:
select
'declare begin j varchar2(20) = 1;
end;' column
from dual t
and I getting thefollowing error:
ORA-01756: quoted string not properly terminated
However this works:
select
'declare begin j varchar2(20) = 1'||';'||'
end;' column
from dual t
and this works as well:
select+
'declare begin j varchar2(20) = 1; end;' column
from dual t
What can cause the error. Is there any initialization parameters that need to be set to
make the first SQL working
Thanks
groxy