OraFAQ Forum: SQL & PL/SQL » SQL-Statement too long?

Home » SQL & PL/SQL » SQL & PL/SQL » SQL-Statement too long?

Tue, 15 January 2002 07:15

Achim
Messages: 2
Registered: January 2002

Junior Member

How does it come, that a 16 kB Query works on Ora 817 but doesn't execute with Ora 805? It is truncated after app. 4 kb. What should I do?

Tue, 15 January 2002 08:01

Vishnu Bhavaraju
Messages: 6
Registered: January 2002

Junior Member

Is it ?
I faced the same problem with the interface between essbase (a mddb) and oracle . Try using views instead of lengthy sub-selects.

Previous Topic:	Help in Oracle trigger
Next Topic:	Killing a user session

Goto Forum:

]

Current Time: Tue May 30 13:31:10 CDT 2023