Recent content by 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

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...