Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: generating sequence from access link table
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