Search:

I think so that there is no limit for the command line argument.

yes bulk collect can be used in the ref cursor : condition only one DML statement is used inisde the forall and secondly the reference to the collection should be made inside the forall.

try to break the join into multiple set . and then using the concept of cursor prepare the reasonalble set of data to work and go ahead with the nested cursor. this will help you for the performation...

you can make declare the associated array in the specification of the package and once the arrays are populated don't delete it and you can use in other procedure inside the same packages.