hi,

i am trying to compile a procedure,it is taking a long time and i am getting the error ORA-03113: end-of-file on communication channel.
The procedure is fetching some data's from the remote database.i am able to login to the remote datbase using the sqlplus, also i am able to take the count of the tables located in the remote db.Is there any problem in the procedure code, or some problem in the network.

give some suggestions.....
the procedure is attached.....

thanks in advance