Hi all,
I tried the approach mentioned below. I have good news and bad news.
The good ones are that Oracle seems to accept it (server version is
10g). I generated a query with some 50 OR'ed IN clauses, with ~900
elements each, for a total of around 45000 elements. The SQL query (text
format) weighted about 400kB. Big, but nothing serious, I think.
The bad news (for me) is that Oracle rejected the query with a ORA-04031
error, " unable to allocate 399448 bytes of shared memory", which tells
me that probably the DB admins (those that won't allow me to use temp
tables), don't allow me to create a 400kB query neither.
So for the short term, I'll have to stick with the 50 queries and local
filtering. For the future, my customer has nearly approved a project to
mirror the remote data warehouse locally so that we can do anything we
want with it.
Thanks to all who replied and for the proposed ideas.
Best regards
J.
El 24/10/11 16:30, Jorge Gonzalez escribió:
El 24/10/11 16:15, Alexander Hartmaier escribió:
Why don't you use the column IN (...) OR column IN (...) solution?
I'd like to see this as a patch for the Oracle SQLMaker.
Cheers, Alex
I have it on my (urgent) TO-DO list. Promise I'll check back with the
results. Honest :-)
BR
J.
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive:
http://www.grokbase.com/group/[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
