On Nov 2, 5:48 am, F van Nimwegen <fred.van.nimwe..._at_gmail.com> wrote:
> 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
>
> readhttp://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb04c...
> for further information
I did go there - I probably missed something. I'll
try again. Thanks for the response. I'll let you know
what happens.
Received on Fri Nov 02 2007 - 07:41:08 CDT
