Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> inserting null in XMLType

inserting null in XMLType

From: Aakash <bordia_at_gmail.com>
Date: 29 Nov 2006 22:28:46 -0800
Message-ID: <1164868126.670708.190060@l39g2000cwd.googlegroups.com> 





Hi, my table has 2 xml columns and am trying to insert values using
host variables.


insert into xmltab values(XMLType(:H0),  XMLType(:H1))
Unfortunately one of these host variables (or both) is NULL and when
its NULL, oracle complains.



What is the way to insert NULL in such situations?



Thanks


Aakash
Received on Thu Nov 30 2006 - 00:28:46 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US