http://qs1969.pair.com?node_id=11139258


in reply to oracle temp table does not exist

What oracle version?

Does the same SQL work when given directly to the server (via SQLplus, for example)?

Catch perl errors, DB errors; what do they say? (your code checks some but not all)

(after the connect line, perhaps insert:

$dbh->{RaiseError} = 1;
to have db errors thrown in your face immediately)