Use of sequences over db link

How can 1 use sequences over a dblink

I do a query such as ...
select pdmlogseq.nextval_at_d704 from dual;

This works

An insert such as...
insert ....
pdmlogseq.nextval_at_d704);

Works but then the query:
select pdmlogseq.currval_at_d704 from dual;

Fails: With sequence not difined for this session...

How can I (should I do the following three queries with a sequence over a dblink!??!

1)insert ....
pdmlogseq.nextval_at_d704);
2) select pdmlogseq.currval_at_d704 from dual; 3) select pdmlogseq.nextval_at_d704 from dual;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 15 1999 - 09:15:37 CST