Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace function not working as expected

622829Feb 26 2008 — edited Feb 26 2008
I can't figure out why the replace() function isn't working consistently. Here's the string of a record I'm trying to modify before displaying (I want the image itself to display and not the HTML <IMG> tag info):

prize pic

<IMG SRC = "http://www.budevser.com/UIMAGES/123779007791424194_prizepic.jpg">


Here are my 3 calls to the replace() function:
temp_string := replace(description_in, '/&lt;', '<');
temp_string := replace(description_in, '>', '>');
temp_string := replace(description_in, '"', '"');


However, the result still shows the <IMG> tag, and not the image itself. When I look at the source code, it shows the following as a result of those replace() function calls:

<IMG SRC = "http://www.budevser.com/UIMAGES/123779007791424194_prizepic.jpg">


I'm confused. It correctly replaced a double-quote mark for the string '"', but it didn't do the same for '<' or for '>'. Any thoughts on why this would be happening?

Message was edited by:
taneal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2008
Added on Feb 26 2008
2 comments
632 views