The statement is too long or too complex

[arunrathna]

I work on an application where the whole business logic is present in database views. The views dont merely represent the table, but has complex SQL statements, calling other views, which call other views. The views became very big and I ended up getting this error message 'The statement is too long or too complex'. This error comes when I access the view which calls a series of views in chain. Is there any database settings that I can change to increase the maximum length of a SQL statement or something like that??

Rathna.

 

[Hattusas]

try increasing the statement heap size and application heap size of your database..

Go to control center select your database right click and select configure. Salih Sipahi
Software Engineer.
City of Istanbul Turkey
openyourmind77@yahoo.com

 

[arunrathna]

Thanx for ur reply. It worked after increasing the heap size.