parameter limit for XML datatype

[spider007]

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?

Thanks.

[Serge Rielau]

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