Hanging of select statements/Forms & Procedures
Question posted by: julietmachiwa
(Newbie)
on
August 28th, 2008 08:57 AM
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 !!!!
2
Answers Posted
Can you please post the error message that you are facing?
Quote:
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
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 197,020 network members.
|
