RE: Pull NEXTVAL thru a DB

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 09 Nov 2001 12:14:09 -0800
Message-ID: <F001.003C1446.20011109115611@fatcity.com>

You just selected the next value from a local sequence called some_seq using the dual table located on the link.

What you have to do is to select the next value from the sequence located on the link using the dual table from the local database.

select some_seq.nextval_at_db_link from dual;

I tried it . It works.

Kevin

-----Original Message-----
Sent: Friday, November 09, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L

Is there any way to get the next value of a sequence via a db_link.

I tried

select some_seq.nextval from dual_at_db_link

but it told me the sequence didn't exist. I went to the database where the sequence exists and, using the userid that is in the db_link, I was able to get the next value, so it isn't a permissions problem. Do I have the wrong syntax or is it just not possible?

TIA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: tday6_at_csc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: Pull NEXTVAL thru a DB_LINK