| ORA-03113: end of file on communication channel [message #18159] |
Sat, 12 February 2005 18:34  |
Mack Sundar
Messages: 20
Registered: July 2002
|
Junior Member |
|
|
Hi-
I am using Oracle 9i (9.2.0.1) Personal Edition on Windows 2000 Server. I have a query that consistently gives me a "ORA-03113: end of file on communication channel" on all my environments.
SELECT interaction0.date_entered
FROM ( ( ( (interaction interaction0 LEFT OUTER JOIN audit_data audit_data5
ON ((interaction0.interaction_id = audit_data5.related_id)
AND (UPPER(audit_data5.related_tbl_name) = 'INTERACTION')))
LEFT OUTER JOIN individual individual4 ON (interaction0.individual_contact_id = individual4.individual_id))
LEFT OUTER JOIN customer customer3 ON (interaction0.customer_id = customer3.customer_id))
LEFT OUTER JOIN (e_lead e_lead1
LEFT OUTER JOIN customer customer2 ON (e_lead1.customer_id = customer2.customer_id))
ON (interaction0.lead_id = e_lead1.e_lead_id))
WHERE (((interaction0.lead_id = '2BA2EAA0FFFFFF9501FD51F703A5C541')
AND ((((EXISTS (SELECT 1 FROM e_acl_entry myACLEntry
WHERE ((((myACLEntry.everyone_flag = 1) OR (myACLEntry.agent_id = '49365D8DFFFFFF95004605C7200CDA80'))
AND ((myACLEntry.permission_mask > 8) OR ((myACLEntry.permission_mask > 0)
AND (myACLEntry.permission_mask < 8)))) AND (e_lead1.e_lead_id = myACLEntry.bio_instance_id))))
OR (NOT ((customer2.customer_id IS NULL) OR ((customer2.obsolete_flag = 1)
OR (customer2.obsolete_flag IS NULL))))) OR (NOT ((customer3.customer_id IS NULL)
OR ((customer3.obsolete_flag = 1) OR (customer3.obsolete_flag IS NULL)))))
OR (NOT ((individual4.individual_id IS NULL) OR ((individual4.obsolete_flag = 1)
OR (individual4.obsolete_flag IS NULL)))))) AND (interaction0.obsolete_flag = 0))
ORDER BY audit_data5.date_inserted DESC, audit_data5.date_updated DESC, interaction0.interaction_id ASC
Can somebody help me with this problem? Any tips are appreciated.
Thanks,
Mahesh
|
|
|
|
|
|
| Re: ORA-03113: end of file on communication channel [message #112829 is a reply to message #18159] |
Tue, 29 March 2005 10:25  |
Hoornet
Messages: 4
Registered: March 2005
|
Junior Member |
|
|
I have a simmilar problem, but i'm making my sql call from my application.
everything is ok, but when i say: INSERT INTO INVALIDNOST ( OSE_ID, OPE_ID, INV_VPIS, INV_KATEGORIJA, INV_PROCENT_OKVARE, INV_DAT_NAST_OKVARE, INV_DAT_NAST_INVALIDNOSTI, INV_ST_SKLEPA, INV_DAT_SKLEPA, INV_AKTIVNO, INV_FAKTOR, INV_OPIS) VALUES( 7822, 666, SYSDATE, '4', 0, NULL, NULL, '', NULL, -1, 0.000000, '' );
it says:
Description: ORA-03113: end-of-file on communication channel
Source: OraOLEDB
The same sql is easily run through sql plus...
I'm really stuck. Can anyone help?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
