""uva raj"" <[EMAIL PROTECTED]> wrote > i want to execute a batch with 1000 statements. > is there any limit for number of statements or size. > please reveal.
If you mean how many statements in a transaction is supportted, then the de-facto limit depends on your statement resource consumption. There are various resources limits of the system, eg. number of open fds, RAM size, disk space ... If you statements are sane enough, then 1000 statements per transaction is never a problem. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly