I have a procedure running an update query. The total number of records involved in the process is just about 2000. But when I try to run it from SQL PLUS, my application crashes.
Does anyone know why this is happening and what can be done??
Any error messages ? Please give some specifics.
Does it work fine for SELECTS or not ?
If it crashes for even selects, then installation problems. Try on another terminal and update and see just to confirm whether its DB problem or Desktop problem .