
July 24th, 2005, 11:04 AM
|
|
Contributing User
|
|
Join Date: Oct 2004
Posts: 46
Time spent in forums: 6 h 36 m 29 sec
Reputation Power: 4
|
|
|
Varrays without limit?
I faced a t-sql code that the programmer used a one column temporary table for saving result from another select.
It think this can be done using varray in pl/sql(In fact there is no array in t-sql,if was then programmer used it).
But the problem is I do not know what is the max number of rows can be retrieved from select so I can 't define limit of varray.
Is there any solution?Should I use pl/sql tables or just global temporary tables?
Thanks
|