'ORA-01756: quoted string not properly terminated'

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