View Single Post

   
  #2 (permalink)  
Old 05-10-2008, 02:02 PM
Serge Rielau
 
Posts: n/a
Default Re: parameter limit for XML datatype

spider007 wrote:
> Hi,
>
> I want to pass a 2-3GB file as a parameter (XML type) to a Stored
> procedure. Is that possible? What is the max limit of parameter size
> for XML datatype?

There is a limit of 2GB for CLOBs (which I presume your file to be in
the end).
I'm curious why is this file so big?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Reply With Quote