If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: I'm stumped

I have a problem with two Oracle SQL scripts. The queries generate a
ORA-04030 error. The error code says out of process memory when trying
to allocate nnn bytes (callheap, temporary storage).

I have experimented with the SQL. In the one case, the script will run
perfectly if I remove the "order by" clause. In the other case, it
runs perfectly removing the "union" statement (it does not have either
group by or order by clause).

The production equivalent files run perfectly in production but also
get ORA-04030 errors when running on the development computer.

My CS&T Operations/DBA's have already decreased sortarea size as suggested in a Oracle Metalink "solution". The DBA's now say that this is a programming error that Oracle does not detect as its syntax is correct, like an unintended cartesian product.

The software change I made was which column name to decode, nothing
dealing with the from clause, where clause or order_by/union clauses.