Re: MSSQLServer->Oracle: Identity and returning a result set using oracle procedure or function

Home -> Community -> Usenet -> c.d.o.server -> Re: MSSQLServer->Oracle: Identity and returning a result set using oracle procedure or function

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 29 Aug 2001 10:03:31 +0100
Message-ID: <3b8cafe5$0$8510$ed9e5944@reading.news.pipex.net>

s'easy just set
_WRITERS_BLOCK_READERS=TRUE and
_READERS_BLOCK_WRITERS=TRUE and your done.

Ooops forgot you also have to bounce your instance, your machine and your network to get this to work correctly.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:u3d6bg2hn.fsf_at_verizon.net...


> On Tue, 28 Aug 2001, dag-arne_at_matreweb.com.antispam wrote:

>

> >

> >> Sorry for venting. Just check how often I answered those 2

> >> questions. I'm getting fed up with it.

> >

> > How to make Oracle case insensitive when searching?

> > Sorry, just couldn't resist... Did you flip out now?

>

> I'm trying to get Oracle to act like SQLServer ...

> --

> Galen Boyer

> It seems to me, I remember every single thing I know.

Received on Wed Aug 29 2001 - 04:03:31 CDT