EOF communication error when two integer type variables are compared.
784398Jul 12 2010 — edited Jul 14 2010Hi guys,
Im using Oracle Database 10g Release 10.1.0.2.0 - Production , on a desktop pc windows xp 32 bit. I simply installed it and did not apply any patches.
here is my situation code in pl/sql procedure I have written. I am running the proc with sqldbx personal edition from another pc which is xp 32 bit.
if (aAgentRateProfile <> gAgentRateProfile) then
raise dynsql.incorrect_agentrate_profile;
end if;
both aAgentRateProfile , gAgentRateProfile variables are integer type and I have declared them as TABLE%COLUMN TYPE.
Problem:
Whenever this piece of code is executed, oracle crashes, it shows end of file communication error error code is ORA-03113: end-of-file on communication channel.
I simply tried like if (5 <> 5) it works fine.
The values coming for aAgentRateProfile = 2 , and gAgentRateProfile = 2 , so 2 <> 2 right ? . So what might be causing the problem ? Is it any bug in oracle ? because this is
a simple integer comparison and there is nothing that could go wrong here.