in reply to Problem in Executing PL/SQL block with Perl

Did you try running that exact same query in your favourite GUI or command-line SQL interface? Cause, though I don't know for sure, I would bet that the /SELECT.*INTO/ statement does not return results..!

How about you try running this query without the INTO<table> bit.. if you must populate your temporary table, then why not run an additional SELECT from your newly created table?

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.

In Section Seekers of Perl Wisdom