I am migrating the application from old environment (PERL 5.004, CGI 2.36, DBI 0.91) to new environment (PERL 5.6.0, CGI 2.68, DBI 1.14). One of the SQL queries in PERL program not executing. It is a query in which I am selecting about 40 fields from a single database table and SUM functions is used on most of the fiedls. There is no error in query itself because It is running fine in SQL PLUS. If I take out some of the fields (reduce the no. of fields in the select statement) then the query executes but It does not execute if I include all the required fields in select statement. The execute statement $csr->execute(); does not return.
Thanks, [EMAIL PROTECTED]
