no regexp_replace in pl/sql developer 6.0.5

[key_ray]

i get: ORA-00904: invalid column name

after submitting select regexp_replace('ellen hildi smith','(.*) (.*) (.*)','\3, \1 \2') from dual;

whereas in an sqllus session, started on the same machine as pl/sqldev, connecting to the same 10g db:

i get:

REGEXP_REPLACE('EL
------------------
smith, ellen hildi

as expected!

Bug in pl/sql , some setting?
any help is appreciated

Regrds raymond

 

[Marco Kalter]

Works fine for me on 10g. It only fails with ORA-00904 when connected to 9.2. Are you sure you are connected to the same 10g database? You could run select * from v$version to be sure.

 

[key_ray]

Hi,

Just tried again.

All fine!!!!!!!!!

Indeed most likely did not use 10g the first time.
Now I think of it, we recently altered the tnsnames entires (due do different servers) and this may wel have caused the mixup!

Thanks for the response.

Sorry for the inconvenience

Raymond