Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'ORA-01756: quoted string not properly terminated'

'ORA-01756: quoted string not properly terminated'

From: <sanjeev.atvankar_at_gmail.com>
Date: Sat, 16 Jun 2007 08:49:12 -0700
Message-ID: <1182008952.880716.321130@p77g2000hsh.googlegroups.com>


Hi Gurus,

I have table as follows

create table T1
(
id number,
name varchar2(30)
)

I have written the Code as follows

decalre
  emp_rec emp%rowtype;
  cursor c1 is select empno,ename from emp; begin

   open c1;
   fetch c1 into emp_rec;
   while c1%found
    loop
      insert into T1 (id,name) values(emp_rec.id,emp_rec.name);     end loop;

    commit;
end;

I have following data in emp table

empno ename


1                Sanjeev
2                Smith
3                Scott
4                D'Costa

empno 1,2 and 3 are inserted properly.

But when I tried to insert empno 4 it gives me the following error. 'ORA-01756: quoted string not properly terminated' i.e. when Cursor (emp_rec.name=D'Costa) contains the value as D'Costa.

If it is manually then I can insert as D''Costa but How would i do this when dynamically.

Thanking in Advance
Sanjeev
sanjeev.atvankar_at_gmail.com Received on Sat Jun 16 2007 - 10:49:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US