Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: generating sequence from access link table

Re: generating sequence from access link table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Dec 1998 00:07:53 +0100
Message-ID: <368177C9.B08F0B1F@sybrandb.demon.nl>


Hi David,
Yes, this is possible, had to do this myself once. What you'll need is a pl/sql procedure on the server generating the next sequence number (basically select sequence.nextval into var from dual;). This pl/sql procedure needs to be called through ODBC in an VBA procedure hooked up to the proper event. Now, currently I don't remember the exact syntax to call a pl/sql procedure in odbc. I know however it IS possible.

Hth,

Sybrand Bakker, Oracle DBA

Dave Nguyen wrote:

> can anyone please tell me if this is possible? I have
> a link table from access 97 to a table in oracle
> 7.3.4. I want to create sequence so that it performs
> just like access has autonumber for its primaty key.
> how can i go about doing this so that as they add
> records through an access form, it will assign the
> next sequence #. sorry if this is not clear ...
> thanks in advance,
> Dave
>
> *** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ***


Received on Wed Dec 23 1998 - 17:07:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US