-
Hi ,
I am trying to query the remote seq (exists in remote database) using the following statement
select schema.sequencename.nextval from dual@remotedatabase ;
I get "sequence does't exist".
Can we use remote sequences & stored procedures ? If so, could you please explain
I am using 8.1.7 .
Thanks
kumar
-
Whats happening here is your statement is trying to access the 'sequencename' under 'schema' in your local database and is accessing the 'dual' table from remote db.
Isn't this exactly the opposite wrt what you want ?
-
I agree with you !!
Then, What would be the syntax ? Please explain
Please test on your database
Thanks
-
SELECT schema.sequence.nextval@db-link from dual;
-amar
-
-
Thanks you verymuch. You save my day.
kumar