There is an alternative - which I quite like -
which is to use a VARRAY as the target
of a bulk collect - then if the user tries
to get too many rows the package raises
an exception.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Connor McDonald wrote in message <3B0923C3.3992_at_yahoo.com>...
>
>As well as being the only way to have an 'upper limit' on how much you
>'bulk collect'...
>
Received on Tue May 22 2001 - 15:16:54 CDT
