Hanging of select statements/Forms & Procedures

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • julietmachiwa
    New Member
    • Oct 2007
    • 14

    Hanging of select statements/Forms & Procedures

    I purged my database and rebuild indexes. The system has started hanging/freezing. Some Forms are not working & some select statement & Procedures are also not running. All these were OK before. On error messages are coming. What can be the cause and Solution . Using Oracle 8. Have tested with Database tools , the system hangs if you highlight some the procedures. These procedures compile well thru SQL Plus. !!Pliz help !!!!
  • amitpatel66
    Recognized Expert Top Contributor
    • Mar 2007
    • 2358

    #2
    Can you please post the error message that you are facing?

    Comment

    • julietmachiwa
      New Member
      • Oct 2007
      • 14

      #3
      Originally posted by julietmachiwa
      I purged my database and rebuild indexes. The system has started hanging/freezing. Some Forms are not working & some select statement & Procedures are also not running. All these were OK before. On error messages are coming. What can be the cause and Solution . Using Oracle 8. Have tested with Database tools , the system hangs if you highlight some the procedures. These procedures compile well thru SQL Plus. !!Pliz help !!!!
      NO error message is being shown

      Comment

      Working...