Yikes, this is the nightmare oracle catch all communication error - don't know if you've checked metalink (or if u have an account for it) but worth checking it out just for the steps to gp through to try to track it down : http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=17613.1 &p_showHeader=1&p_showHelp=1
if not, pm me off list and i'll forward it to you... Gord Gordon Thomas Oracle DBA Interactive Services Channel Four Television [EMAIL PROTECTED] Tel +44 (0) 20 7306 8278 Mob +44 (0) 79 6850 2066 Pag +44 (0) 76 9323 2458 http://www.channel4.com -----Original Message----- From: Osullivan Karl (RKB) Senior Analyst/Programmer [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 10:48 To: 'CF - Development Group' Subject: [ cf-dev ] Oracle / CF Error Hi, Happy New Year to you all. I know I've run this one past the group before, but I thought I'd give it another go as I'm completely stuck. We use the Oracle native driver in CF (SQL Plus/SQLnet 8.1.5) to talk to the Oracle database. This works absolutely fine, and will bring back 1 or 1000 records, depending on the selection criteria. We also have the same software on a server the other side of our firewall (using Borderware v.6.5 (Feature Pack A)) with a port through the firewall to the same Oracle database. This also uses the native driver. When we run queries (the same ones I was talking about above) then sometimes we get the message: Error Diagnostic Information Oracle Error Code = 3113 ORA-03113: end-of-file on communication channel There seems to be no pattern to this. Sometimes it's on queries that only return 30 records, and sometimes on queries that return 200 records. But then again it can work on queries that return 500 records! It's the same query, the only difference is that is running through the firewall. If I take ColdFusion out of the equation and run the query through SQL/Plus on the firewall server (so going through the same port as with CF) then the queries run fine everytime, which makes me think it is something to do with CF. I've also tried the Merant Oracle ODBC driver and this produces the same message. Does anyone have any ideas? Please!! Karl O'Sullivan Senior Analyst Programmer University Hospitals Coventry and Warwickshire NHS Trust Tel: 024 7660 2020 x7578 [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
