Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get a sequence nextval through a database link.

weekendMay 14 2009 — edited Feb 3 2012
HI

when i execute
SELECT UserName@DB_Link_Name.sequence_Name.nextval FROM dual;

it give error "ORA-04054:database link "DB_Link_Name.sequence_Name.nextval" does not exist.
I have also try it with @DB_Link_Name.Com.sequence_ but it didn't worked either, Oracle didn't understand where database link end and where sequence start, please advise how to fix it?

Wisehs
J a w a d
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2012
Added on May 14 2009
6 comments
20,758 views