Home » SQL & PL/SQL » SQL & PL/SQL » SQL-Statement too long?
SQL-Statement too long? [message #120] Tue, 15 January 2002 07:15 Go to next message
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?

Report message to a moderator

Re: SQL-Statement too long? [message #121 is a reply to message #120] Tue, 15 January 2002 08:01 Go to previous message
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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 23 02:30:41 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.