I am creating stored procs using SQL Plus by copying and pasting the code. It works great with most sprocs. If sproc is more then 135-150 lines long, SQL Plus stops responding and I have to restart it. Sproc is not created. What's the problem and how can I get around it? OS is WinXP. I'd like to run 'show err' after that to see compilation errors.