If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I have a procedure which crashes when I try to execute it. The table it works on has around 300K + records , but I have proper indexes on the fields.
Does anyone know if I need to do anything else to get it going ??

Don't Close your Sql Plus Session becuase the Procedure is Running on the Server. It may take a while but it's working .. If you want to make sure, you can insert any message somewhere after every 10000 records or Just check the results from Other SQL Plus session.