ORA-01756: quoted string not properly terminated

[balajiyes]

hi can u send accross the code,

u will get the error when u r using a string
(eg) '23-SEP-2002'
if u want to replace ' use CHR(39)

aim correct?
thnx,