Get an event 10046 trace. That will show you the exact problem. -- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Engin-A Guelen [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 07, 2005 9:03 AM To: [email protected] Subject: DBI-Problem Hello Tim, i am using Perl Version 5.8.7 with DBI v1.48 and DBD-Oracle 1.16. Yesterday I tried to write about 100 Records into a table with serveral dozen columns within an Oracle 9i - Database. I prepared the insert - stmt once and for each record modified the respective perl-variables. After about half a dozen records the script just hang (DBI-Trace hang when dumping the different bind variables). I could solve the problem by closing and re-preparing the statement-handle after every insert. Do you know about any problems in this area ? Thanks in advance! Mit freundlichen Grüßen / Kind Regards Engin Gülen -------------------------------------------------------------------------- Sinius GmbH Chief Information Office (CIO) Applikationsmanagement Solmsstr. 83 D-60486 Frankfurt am Main Telefon: ++49 069 7584-1758 Fax: ++49 069 7584-1766 Mail: [EMAIL PROTECTED] Web-Site: www.sinius.de Ein Unternehmen von Siemens Business Services -------------------------------------------------------------------------- This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
