DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Precedure crashes

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Crashes how? Any specific error message returned? Any dump files or logs or anything?

    - Chris

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

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

  4. #4
    Join Date
    Feb 2001
    Posts
    184
    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

  5. #5
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Yes, I guess so. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width