Baffling Problem with Pl/SQL Package

From: <dejaadas_at_my-deja.com>
Date: Tue, 28 Dec 1999 21:13:44 GMT
Message-ID: <84b8nq$gn5$1@nnrp1.deja.com>

Hi
I have a package with 10 functions. The package compiles fine but when I run it (all 10 fucntions are executed in sequence), at one point, a cursor gets opened but the process sleeps forever just before the "FETCH". I have tried Cursor For Loops, Explicit open/fetch, and some other tricks but it does not help. There are no error messages of any kind. The cursor does not do anything extraordinary and does not have to handle more than 10,000 rows as input. Has anyone experienced such issues ? We are on Oracle 7.2.3 and PL/SQL 2.3.2.2.

Any information would help.

Thanks
Das

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 28 1999 - 15:13:44 CST