Oracle-L: Oracle and MS-Access sequence problems

From: Thiele, Dave <dthiele_at_EMS1.UWSP.EDU>
Date: Thu, 18 Jan 1996 15:27:10 -0600
Message-Id: <9601182204.AA28510@alice.jcc.com>

Hi,

We've run into a snag with processing Oracle tables attached to a Microso= ft
Access Database. =20

We want to be able to use Oracle's Sequence generator to create unique ID's on row-inserts, but have been unable to get MS-Access = to
recognize any way to accomplish this - it doesn't recognize the SQL state= ment
with the "<sequence>.nextval" in it.

Any ideas ??

Dave Thiele - University of Wisconsin Stevens Point dthiele_at_ems1.uwsp.edu

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Dave Thiele
Administrative Information Systems
University of Wisconsin - Stevens Point 004-SSC Stevens Point, WI 54481
Tel: 715-346-3904
Fax: 715-346-2558
Email: dthiele_at_ems1.uwsp.edu
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Received on Thu Jan 18 1996 - 17:04:49 CST