Problems with Escape Character

[Ramon van der Weiden]

Hi,

I've problems using Escape Characters in pl/sql Developer.

I want to search records which contain the text Philips_IP&S_-_FSR.

For this I've build the following query :
select o117323.code
from fsr_target.dwh_product_division o117323
where o117323.code in 'Philips_IP&&S_-_FSR';
This query doesn't return any records. When I execute this query in Oracle SQL Developer it does return records.

When I execute the following query in pl/sql Developer it asks me for a value for parameter S_.
select o117323.code
from fsr_target.dwh_product_division o117323
where o117323.code in 'Philips_IP&S_-_FSR';

What am I doing wrong ?

 

[BWendling]

This is a confirmed bug in 7.0.1066.

http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=002880

 

[Marco Kalter]

It's fixed in 7.0.2, which is planned for next monday.

 

[Ramon van der Weiden]

Thanks for the replies and sorry for the double posting.

-------------------
Ramon van der Weiden