PL/SQL

Hello out there,

first of all, I have to apologize for my bad English.

Well, I have a problem concerning PL/SQL-Batches. In a client/server project I need to use PL/SQL.

I can compile my program and execute it without any problems. Then 15 minutes later I try it again (using the same data) and the system crashes. That means 2 minutes after executing Oracle stops my job and I receive the message "ORA-....Lost communication..". That seems to be a kind of timeout.

After I have recompiled it (no changes were made) executing causes no probems. Sometimes I can execute it the whole day without any problems.

So what can I do to keep my program executable without recompiling it all the time.

Thanks for your help,

Uwe

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet