[HELP, OWS] Can PL/SQL screw OWS 2.xx?

From: Max Lambertini <maxl_at_dsnet.niente-trippa-questa-sera.it>
Date: 1997/12/09
Message-ID: <348D8593.37BE4E11_at_dsnet.niente-trippa-questa-sera.it>#1/1


Ok, here's the problem...

I've got some pl/sql stored procs that _seem_ to go fine when launched, but (imho) cause WRBProc.exe to go zombie, thus wasting process space under NT.

Recently we moved Oracle servers under a Digital Unix machine and I moved the aforementioned stored procs, with their table. I hoped that a new server, and a far better operating system, could solve my problems...

Indeed, the problem did show up again....:-( Needless to say, my procedures don't have any closed loop, all cursors happen to get close, I chech for hCurs%NOTFOUND when iterating on tables.....

So, is there any Oracle guru that can help me finding why WRBProc.exe and its Unix equivalent, wrbc go zombie so frequently?

Any help is really appreciated!

Saluti,Max

-- 
+------------------------------------------------+

|Massimiliano Lambertini |
+------------------------------------------------+
|To email me, please remove: |
|".niente-trippa-questa-sera" from my address |
|Per scrivermi togliete dal mio indirizzo |
|".niente-trippa-questa-sera" |
+------------------------------------------------+
Received on Tue Dec 09 1997 - 00:00:00 CET

Original text of this message