anuu_radhaa_at_yahoo.com wrote:
> Hi,
>
> Due my experienced (so-called) seniors who designed the app and the
> database, i have been given a task to learn more about ORA-4030. The
> design of the application is such that, user will be allowed to set the
> filter to exclude order information placed which inturn is converted to
> LIKE statement.
>
> It turned out to be that the end-user has set 640 filters. This
> resulted to more than 2000 lines of SQL which is dynamically generated.
Just agreeing with gazzag ... this needs to be dumped and redesigned.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Nov 17 2005 - 10:11:30 CST
