Re: HELP

You have to do this within one transaction with the isolation level set to serializable (also known as repeatable read). You can achieve that by issuing an 'alter session set transaction read only;' (which will restrict your actual transaction to read-only operations) or you have to start up your database with serializable=true in init.ora.

Gerard H. Pille wrote:
>
> I believe it allready existed in Oracle V5, it's the infamous
> "select count(*) ..."
>
> Enrique Aviles <eaviles_at_ix.netcom.com> schreef in artikel
> <342AEA44.4628_at_ix.netcom.com>...
> > Hi
> >
> > I know this has been asked before but I didn't see any
> > convincing answers so here we go again.
> >
> > Can I get the number of rows that a cursor is selecting
> > before I execute the first fetch?
> >
> > I want to do that so that I can malloc() the exact amount
> > of memory needed to hold the data coming from the cursor (I'm
> > using Pro*C). Does an internal Oracle structure/variable get
> > set with the number of rows selected after I open the cursor?
> >
> > Will this be available in Oracle8?
> >
> > Please respond by mail.
> >
> > Thanks,
> >
> > Enrique
> >
 

-- 
Martin Haltmayer