in reply to DBI/Oracle Nested SELECT query

It should work. Try to run your script with tracing. 
$ DBI_TRACE=2 ./yourscript.pl

[download]
See TRACING chapter in DBI for the details.

In Section Seekers of Perl Wisdom