Re: xmltype column - how do I get contents?

On Nov 1, 4:29 pm, ken quirici <ken.quir..._at_excite.com> wrote:
> I'm writing a trigger that compares an :old vs. a :new value for a
> column that is
> identified as XMLtype. When I look at the 'create' script that Toad
> generates
> for the table containing this column, there's no storage info - e.g.
> that it's stored
> as a LOB.
>
> Since I'm starting off w/o knowing the contents of the column I can't
> supply
> a XMLpath string to extractvalue for example. I tried
>
> select
> ...
> extractvalue(<columnname>,'')
> ...
>
> hoping it would interpret that as meaning 'give me everything', but it
> just
> returned nulls.
>
> I tried the dbms_lob.substr(<columnname>,100,1) but it returned the
> error 'wrong number or type of arguments in call to substr'.
>
> So how can I get the full contents of the column w/o knowing the
> contents
> of the column, if you follow my meaning.

<column_name>.getCLOBVal() converts xmltype to a clob

read http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb04cre.htm#ADXDB0400 for further information Received on Fri Nov 02 2007 - 04:48:27 CDT