PL/SQL (MOSC)

MOSC Banner

dbms_lob.substr...?

edited Jul 31, 2009 5:31AM in PL/SQL (MOSC) 2 commentsAnswered
 Hi All,

Please find the sample XML file data,

<FileName>1.txt</FileName>
<FileContentType>text/plain</FileContentType>
<FileData>3C5472616E73616374696F6E3E0D0A2020203C5472616E734374783E0D0A2020202020203C5472616E73616374696F6E47726F75703E54414C454E545F4D474D543C2F5472616E73616374696F6E47726F75703E0D0A2020202020203C5072736E4A6F624E61</FileData>
----------------
---------------


By using dbms_lob.substr we can achieve may be.

My requirement is that,either pickup the <FIleData> value or erase the value of <FIleData> node.

can anyone tell me how can i achieve my requirement?

<FileData> node value not fixed it varies each time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center