Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!samsung!uakari.primate.wisc.edu!ames!vsi1!daver!kcdev!genco!rad
From: rad@genco.bungi.com (Bob Daniel)
Newsgroups: comp.databases
Subject: Re: Problem with Oracle PRO*C
Keywords: pro*c, oracle
Message-ID: <176@genco.bungi.com>
Date: 4 Jan 91 15:33:31 GMT
References: <1991Jan3.065418.4767@brolga.cc.uq.oz.au>
Reply-To: rad@genco.bungi.com (Bob Daniel)
Organization: Gentry & Assoc. Excelsior Springs, MO
Lines: 13

In article <1991Jan3.065418.4767@brolga.cc.uq.oz.au> exnirad@brolga.cc.uq.oz.au (Nirad Sharma) writes:
>Oracle V5, SCO Xenix 2.3.2 /386
>  165          }
>  166  no_more_conds:
>  167          EXEC SQL CLOSE QM_C1;
>  168  
>  169  
>  170          /* Copy the supplied values into the datum structures */
>  171          EXEC SQL WHENEVER NOT FOUND GOTO no_more_mult_vals;
>  172          EXEC SQL DECLARE QM_C2 CURSOR FOR

I only have experience with version 6 and have not come across the problem but
you may need to increase the open_cursors in your init.ora file.