end of communication error
I have an update statement, it was working just fine on 10.2.0.3. After upgraded to 10.2.0.5, got end of communication error. The sql:
update daily_posting
set app = 'OC'
where app = 'DD'
and (lpad(account, 10,'0'),amount,SEQ_NUMBER,lpad(regexp_substr(description,'\d+'),10,'0')) in (
select accountnumber, amount, sequencenumber, SERIALNUMBER
from paidchecks
where (accountnumber, serialnumber, amount) in (select lpad(account, 10,'0'),
lpad(checknumber,10,'0'), decode(direction, 'CR', -amount, amount)
from items)
)
;
in the trace file, got this:
*** ACTION NAME:() 2011-06-13 08:38:58.672
*** MODULE NAME:(Golden32.exe) 2011-06-13 08:38:58.672
*** SERVICE NAME:(SYS$USERS) 2011-06-13 08:38:58.672
*** SESSION ID:(445.3065) 2011-06-13 08:38:58.672
update daily_posting
set app = 'OC'
where app = 'DD'
and (lpad(account, 10,'0'),amount,SEQ_NUMBER,lpad(regexp_substr(description,'\d+'),10,'0')) in (
select accountnumber, amount, sequencenumber, SERIALNUMBER
from paidchecks
where (accountnumber, serialnumber, amount) in (select lpad(account, 10,'0'),
lpad(checknumber,10,'0'), decode(direction, 'CR', -amount, amount)
from items)
)
;
in the trace file, got this:
*** ACTION NAME:() 2011-06-13 08:38:58.672
*** MODULE NAME:(Golden32.exe) 2011-06-13 08:38:58.672
*** SERVICE NAME:(SYS$USERS) 2011-06-13 08:38:58.672
*** SESSION ID:(445.3065) 2011-06-13 08:38:58.672
0