Precedure crashes

[rshivagami]

Hi all,

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 ??

Shiva.

[chrisrlong]

Crashes how? Any specific error message returned? Any dump files or logs or anything?

- Chris

[rshivagami]

It does not show any error messages, but my SQLPLUS just hangs up.

[Oracledba8]

Don't worry.

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.

Hope this helps.

Thanks

[rshivagami]

Yes, I guess so. Thanks.