Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

parameter limit for XML datatype

0 views
Skip to first unread message

spider007

unread,
May 7, 2008, 5:48:49 AM5/7/08
to
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

unread,
May 7, 2008, 6:48:32 AM5/7/08
to
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

0 new messages