Search notes:

ORA-00917: missing comma

In the following example, the anonymous PL/SQL block throws the error message ORA-00917: missing comma.

create table tq84_ora_00917 (id integer, txt varchar2(100));

begin
   insert into tq84_ora_00917 (id, txt) values (
      42, 'A 'quoted' word.'
   );
end;
/

This error can be prevented by using the q'…' syntax:

begin
   insert into tq84_ora_00917 (id, txt) values (
      42, q'[A 'quoted' word.]'
   );
end;
/

Cleaning up

drop table tq84_ora_00917;

ORA-00917: missing comma

See also