SQLPlus session question

Hello all,

I have a number of procedure sets that must be executed sequentially.
For example:
I have ProcA1, ProcA2, ProcA3, ProcA4...
When I run these separately within a SQLPlus session, like this:
...
exec ProcA1;
...
They will each complete in a reasonable amount of time (10 to 15 minutes) -
which is just what I expect.
HOWEVER:
If I run them this way:
...
exec ProcA1;
exec ProcA2;
exec ProcA3;
...
They will take FAR longer, and sometimes will not complete for hours.

Any ideas?
Thanks,
Tim

Oracle 9.2.0.1.0
Red Hat Advanced Server 2.?


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].