R&R problem with Oracle9i

cooperds_(Guest) · Post by **cooperds_(Guest)** » Thu Jan 08, 2004 12:18 pm

We have been using R&R for many years against our Oracle tables. We recently upgraded to Oracle9i without any problems on most of our reports. However we have a few that will not run (or more accurately, they will not open). We can recreate the reports and they run fine during the session in which they were created, but if we save it and try to re-open it, it just hangs up again. (We^ve left it overnight and it never opens and never gives an error message.) ____We^ve tried this using Oracle^s ODBC Driver, the ^Microsoft ODBC for Oracle^ driver, and ^PB Merant OEM 3.60 32-bit Oracle8^ driver.__The trigger seems to be doing joins to 3 or more tables. ____The SQL generated by R&R runs fine in other tools -- and as I said it initially works OK within R&R -- but then hangs when we try to re-open the report.____Any ideas what the problem is?____Doug C.