Procedure dying with ORA-03113

[toddyl]

Hi,

I have Oracle installed on a Windows Server 2003 box.
I created a stored procedure and compiled it successfully.
I opened TOAD and opened two seperate SQL Editor sessions for my user. In one of these windows I attempted to call my procedure. It appears to work for a little while then dies with error ORA-03113 -- End of file on communication channel. If I go to the other SQL Editor window and run a select statement on any table in the DB I get the appropriate results back. In fact I can run a select/update from the same SQL Editor session that I ran my procedure from and it will work fine.

What is going on that my procedure is dying?

Thanks,

Tom

 

[toddyl]

I read on various discussion forums to try and update the verison of Oracle in use. I had 9.2.0.1.0 installed when this problem was occurring. I upgraded to 9.2.0.5.0 and everything seems to be ok.

If the problem re-surfaces I'll let you know.