I believe the SQL statement limit is 32 KB for Oracle 9i but check it out in the manuals (Server Ref or SQL Ref). Also this is something that could well be version specific. Anyway I hope I never need a statement anywhere near 32 KB!! Cheers, Chris Quoting Ranko Mosic <ranko.mosic@xxxxxxxxx>: > What is it ?=20 > Also what is max size of sql query ?=20 > > Thanks, Ranko. > -- > //www.freelists.org/webpage/oracle-l > Chris Dunscombe www.christallize.com -- //www.freelists.org/webpage/oracle-l