Re: Pull NEXTVAL thru a DB_LINK
Grant select on SEQ. to the user that you have used to create DB_LINK.. and then it should work.. GRANT SELECT ON some_seq to ; Have fun.. HTH Make a FREE long distance call from your PC! http://www.eboom.com/free/ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 11:20 AM > Is there any way to get the next value of a sequence via a db_link. > > I tried > > select some_seq.nextval from dual@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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Nikunj Gupta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Pull NEXTVAL thru a DB_LINK
Workaround: On the remote system (where the sequence exists) create a view: create or replace view vSome_Seq as select some_seq.NEXTVAL from dual; Then, you can query it remotely: select nextval from vSome_Seq@db_link; Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 2:20 PM > Is there any way to get the next value of a sequence via a db_link. > > I tried > > select some_seq.nextval from dual@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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Igor Neyman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Pull NEXTVAL thru a DB_LINK
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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Pull NEXTVAL thru a DB_LINK
Is there any way to get the next value of a sequence via a db_link. I tried select some_seq.nextval from dual@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).