Home » SQL & PL/SQL » Client Tools » Replacing &amp (oracle 10.2.0.4 - Windows server 2003)
Replacing &amp [message #609315] Wed, 05 March 2014 06:16 Go to next message
muktha_22
Messages: 408
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 '%&%'
         THEN 
         select replace(t1 ,'&','&') into t1 from dual;
END IF;


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

./fa/11739/0/.

Kindly help me out.

Thanks
Muktha

  • Attachment: amp.JPG
    (Size: 14.06KB, Downloaded 109 times)
Re: Replacing &amp [message #609316 is a reply to message #609315] Wed, 05 March 2014 06:37 Go to previous message
muktha_22
Messages: 408
Registered: December 2009
Senior Member
Hi All,

I found the answer.

In sqlplus window, set the Define as off

"SET DEFINE OFF"

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


Current Time: Sat Dec 20 21:36:45 CST 2014

Total time taken to generate the page: 0.07504 seconds