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.