Hi,

Herewith sending the following scenario where i am come across

ORA-03113 end-of-file on communication channel

while giving the update statement.


table a
-------
emp no projid
------ ------
101
102
103
104
105
106



table b
-------
emp no projid unitid
------ ------ ------
101 401 1
102 402 2
103 403 3
104 405 4
105 406 5
106 407 6
107
108
109

I want to update the values of projid from table b to table a projid.
There is no link between these two tables.


The update statement is for one record...

update (table a) a set a.proj_id = (select b.projid from (table b) b,
(table a) a where
a.empno = b.empno) where a.empno = 101


Even for one statement it is end of communication channel..

for all the records the system is hanging..

what is went wrong in this..

any guru can enlighten this..

cheers,
Mohan.


Oracle LazyDBA home page