Hi

Is there a maximum number of fields for Oracle9?

I have a large query returning 196 fields from a complex query using several union all into a TOraclewwDataSet.
Everything runs fine.
But when I add 5 extra (string and date) fields the query returns an ORA-03113 End of Communication Channel-error on Oracle9, and the connection to the database is lost.
It works fine on Oracle10 and Oracle11.
If the query is executed in PL/SQLDeveloper on the Oracle9-database, it works fine.
We use Delphi XE2 and DOA ??

So: Is there some sort of maximum number of fields for Oracle9?


Last edited by Ruudbern; 04/28/14 08:57 AM.