Re: problem with DBD::Oracle - timeout ?

2009-04-08 Thread John Scoles
Would be helpful it you told us your DBD::Oracle and Oracle Client version as well There are limits on what you can do with a remote view id the view has a LOB. Does your view have a CLOB or BLOB? Deepening on your DBD::Oracle version we might be able to a very detailed OCI trace on what is

problem with DBD::Oracle - timeout ?

2009-04-08 Thread Croteau, Sylvain
Hello, I got a strange problem, and I need help to solve this. I need to run an Oracle stored proc from perl. So far, nothing exceptionnal. The problem is that I'm using a db link in the Oracle stored proc. I can run it successfully from Toad and sqlplus, but I'm having issue when run from p