Re: Baffling Problem with Pl/SQL Package

dejaadas wrote:
>
>
> 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.
>

Are you calling each function from within the prior function? If so, and you are also calling Cursor loops with in already open cursor loops you may be running into stack problems. Just a guess , but I've seen similiar things happen in process with alot of nested function calls. See if you are exceeding Oracles nested loop restrictions.

HTH RC
> Any information would help.
>
> Thanks
> Das
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Posted via CNET Help.com
http://www.help.com/ Received on Tue Dec 28 1999 - 22:30:25 CST