Re: Insert quote into table problem

It looks like you are missing a ' but i can't tell what to do without knowing how the columns are set up and what the string looks like without the extra quote marks.

Please post the original data and the column definitions and then we can help.

Thanks.

Greg Teets
Cincinnati OH

On 1 Jul 2001 05:30:54 -0700, P.J.J.Hageman_at_ict.hva.nl (PeterHageman) wrote:

>I'm trying to insert a row in a table, with
>a field that contains a quote.
>Sql looks like this:
>insert into pctable('1011 KN','1',' 8','10','Amsterdam ','Plein '40-'45');
>I get an error ORA 01756: quoted string not properly terminated.
>How can I get the field with 'Plein '40-'45 into the table?
>
>Greetz,
>
>Peter Hageman
>Hogeschool van Amsterdam
Received on Sun Jul 01 2001 - 08:04:36 CDT