using oracle sequence by odbc in MS ACCESS

I try to use an oracle sequence in ms access

In oracle I created a
sequence

called my sequence

I created a function

create function incrementmyseq (X IN INTEGER) RETURN INTEGER IS

l_status integer default 0;

BEGIN
Select foo.mySEQ.NextVal Into l_status
From DUAL;

RETURN l_status1;
/* Process any Exceptions */
EXCEPTION
    WHEN OTHERS THEN
    Return 0;

END ; then I created a view

create view myseqinc as
select incrementmyseq(1) myseq from dual;

I linked the view myseqinc to a access db ( by odbc)

and know when I open the view in access

the only value I can see for
myseq is

#Deleted

When I do a session with sqlplus

I can see that the value of myseq has been increased by 10

That is not what I want.
1. I just want it to be increased by 1 , and in this case I already tried to configure the init.ora on the cache of sequences which did not work and the no cache option of the seqence did not work either.

2. I want to see the value of the increased sequence in access

Can somebody help me Received on Tue Mar 16 1999 - 08:59:25 CST