Home » SQL & PL/SQL » SQL & PL/SQL » How to get a sequence nextval through a database link. (Oracle10g, Win2003)
How to get a sequence nextval through a database link. [message #403298] Thu, 14 May 2009 12:15 Go to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

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
Re: How to get a sequence nextval through a database link. [message #403299 is a reply to message #403298] Thu, 14 May 2009 12:22 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>please advise how to fix it?
Stop poking yourself in the eye.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

What does sequence have to do with "SELECT UserName"?

What do you expect the query to return & why?
Re: How to get a sequence nextval through a database link. [message #403300 is a reply to message #403298] Thu, 14 May 2009 12:26 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Busy to google??
one hit.
even forum has one thread.

By
Vamsi

[Updated on: Thu, 14 May 2009 12:30]

Report message to a moderator

Re: How to get a sequence nextval through a database link. [message #403302 is a reply to message #403298] Thu, 14 May 2009 12:32 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any good reason to get sequence number from a remote database.
But I can see many problems.

Regards
Michel
Previous Topic: Order of where clause in SQL query. (merged 3)
Next Topic: Database size
Goto Forum:
  


Current Time: Sun Dec 04 20:35:30 CST 2016

Total time taken to generate the page: 0.11220 seconds