Why doesn't this query work?

[Technical Suppor]

I'm using PL/SQL Developer 8.0.4 trying to run this query:

UPDATE account_type act
SET act.short_desc = 'embedded ;'
WHERE ROWNUM = 1;

Returns ORA-01756 quoted string not properly terminated.

Used to work in PL/SQL version 7, what am I missing here? I want semi colon in my data.

Thank you

Tomas

 

[patch]

I created this little test script:

create table account_type (short_desc varchar2(100))
/
insert into account_type values ('test')
/
commit
/
UPDATE account_type act
SET act.short_desc = 'embedded ;'
WHERE ROWNUM = 1
/
select * from account_type
/
drop table account_type purge
/

And it seems to work flawlessly on my 8.0.4.1514 version with a 10.2.0.4.0 database.

 

[Worker]

Works for me too, both in a SQL window and a Command window.

What kind of window are you trying this in?