OraFAQ Forum: Client Tools » Replacing &amp

Home » Other » Client Tools » Replacing &amp (oracle 10.2.0.4 - Windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Replacing &amp [message #609315]

Wed, 05 March 2014 06:16

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Having issue while replacing &amp into & of XML downloaded file.

1) Having a XML file to be uploaded into a table.

2) Trying to make a procedure, in that procedure I am finding and replacing the &amp as below.

IF t1 LIKE '%&amp;%'
         THEN 
         select replace(t1 ,'&amp;','&') into t1 from dual;
END IF;

3) While creating the procedure, getting the pop up message as attached

/forum/fa/11739/0/

.

Kindly help me out.

Thanks
Muktha

Attachment: amp.JPG
(Size: 14.06KB, Downloaded 967 times)

Report message to a moderator

Re: Replacing &amp [message #609316 is a reply to message #609315]

Wed, 05 March 2014 06:37

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

I found the answer.

In sqlplus window, set the Define as off

"SET DEFINE OFF"

Thanks
Muktha

Report message to a moderator

Previous Topic:	Convertion of text from german to english
Next Topic:	How to login to Sql *Plus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 21:41:23 CDT 2023