Session sometimes hangs when doing select in stored procedure 
Author Message
 Session sometimes hangs when doing select in stored procedure

A stored package procedure executes a SELECT, a join of a local table
and a local view. The local view is based on tables in a remote
database through a db-link. The "remote" database is running on the
same physical server as the "local" database. Several other packages
and queries are executing successfully all the time against the remote
database.

The stored procedure seems to work around 75% of the time. The rest of
the time, however, the session just hangs indefinitely. It also locks
the package that was running. The session cannot be killed with ALTER
SYSTEM KILL SESSION, and the database must be restarted to remove it
and release the lock on the package.

Has anyone experienced a similar situation? This is very frustrating
since the session hangs with no error message or indication of what
has gone wrong. I can even run the stored procedure or query on its
own (outside of the package) without the session locking up.

I'm using Oracle 7.3.4



Fri, 22 Feb 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. preserving case when doing selects/compares in stored procedure

2. Trigger doing UNLOAD to file OR calling Store Procedure doing the UNLOAD to file

3. isql hangs when doing a select

4. phantom procedure - mi_prepare() fails sometimes, but sometimes do not

5. Procedure in package hangs sessions

6. Executing a Stored Procedure in a Stored Procedure and selecting on the result

7. return select values in stored procedure to a calling stored procedure

8. Stored procedure only working sometimes

9. Stored Procedure issuing an odd error sometimes...

10. Stored Procedure Only Works Sometimes...

11. doing SELECT after INSERT OR UPDATES in stored proc causes proble ms

12. does set xact_abort off sometimes hang server?


 
Powered by phpBB® Forum Software