Home » RDBMS Server » Server Administration » Single quote character in data causes problems
Single quote character in data causes problems [message #371679] Fri, 24 November 2000 06:03 Go to next message
Dave Platt
Messages: 1
Registered: November 2000
Junior Member
Not certain whether this should be on this site or PL/SQL site.
I have a piece of PL/SQL where if I have a ' character in the data, causes the error ORA-01756: quoted string not properly terminated. I think the offending line is something like:
Address_line := '&Addr1'; (where Addr1 contains ' )
Is there a way of setting the default quote character differently??

Report message to a moderator

Re: Single quote character in data causes problems [message #371680 is a reply to message #371679] Fri, 24 November 2000 08:18 Go to previous message
Alagu
Messages: 6
Registered: November 2000
Junior Member
Hi Dave Platt,

You can give '' two times the single quote or ''' three times. please try it. I'm not sure which of the above will work.

Thanks

Alagappan.N

Report message to a moderator

Previous Topic: Re: Instance Names
Next Topic: Re: Query - whoops - see scripts
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 14:02:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.