Re: problem with JOINs using DBIx::Recordset under apache

1999-12-03 Thread Dhanabal Ekambaram
Hi, Gerald Richter wrote: I guess your mod_perl is compiled as dynamic module (with USE_DSO) and _not_ linked staticly into Apache? Actually, we are using modperl statically compiled with apache. I do not know whether the following will help in identifying the problem: We are running

RE: problem with JOINs using DBIx::Recordset under apache

1999-12-03 Thread Gerald Richter
Hi, I do not know whether the following will help in identifying the problem: We are running Oracle's 'analyze' on all our tables once every day. Oracle support person us told that there is some problem with the cost-based optimization that is done by Oracle (after 'analyze'), which

RE: problem with JOINs using DBIx::Recordset under apache

1999-12-02 Thread Gerald Richter
Hi, We have a problem in using DBIx::Recordset module. Whenever we run the following script through Apache, the first invocation works fine. The second invocation causes Oracle to dump core. The script joins two tables (ie., destination and atomic_destination) and prints a column named