Re: [Dbix-class] Regarding Oracle's 1000 element limit in IN clause

2011-10-22 Thread Darren Duncan
Jorge Gonzalez wrote: One approach could be to load some temporary table with the filter data and then join BIGTABLE with the temp table, but as I said, my Oracle user is very limited and can't create temporary tables, much less load them with data. The best solution is to talk to the DBAs an

Re: [Dbix-class] Regarding Oracle's 1000 element limit in IN clause

2011-10-22 Thread Oleg Kostyuk
Hi Jorge and all, As for me, obvious way to solve this - it's use temporary tables. But you can't. Why? I'm too think that answer to this question is out of scope of this list. But this is main thing, as for me. I think it's not normal, when developer want - and not just want, but have to - have

Re: [Dbix-class] Regarding Oracle's 1000 element limit in IN clause

2011-10-22 Thread Martin J. Evans
On 22/10/2011 11:36, Jorge Gonzalez wrote: Hi all, first of all, I think this question is probably offtopic in this list since it's not DBIx::Class specific, but since I do all my DB development with DBIx::Class I'd like to ask here first. The question is probably of interest for others anywa

[Dbix-class] Regarding Oracle's 1000 element limit in IN clause

2011-10-22 Thread Jorge Gonzalez
Hi all, first of all, I think this question is probably offtopic in this list since it's not DBIx::Class specific, but since I do all my DB development with DBIx::Class I'd like to ask here first. The question is probably of interest for others anyway. This is it: