Sequence and Oracle ODBC 8.01.07.00 driver problem

From: Emiliano Antonello <e.antonello_at_giove.org>
Date: Fri, 08 Feb 2002 16:46:56 GMT
Message-ID: <4iT88.49710$3J1.1401585@news2.tin.it>

I have a local oracle db server 8.1.7 and a remote oracle db server 8.1.7. I need to use a SEQUENCE that is into the remote database. I have created a database link in a local user db that point into the user in remote db. Width ODBC 8.01.07 oracle driver, I execute the following sql statement in local db:

select max_06_area_id.nextval_at_ITALIA from dual

but I receive the error

ORA-02041: client database did not begin a transaction

If I try the statement in SQLPlus it's ok, but with ODBC it dosen't work. Then I supposed that it's the database link that dosen't work in ODBC. I have try to made a SYNONYMOUS but it dosen't work.

How can I resolve this? Thanks. Received on Fri Feb 08 2002 - 10:46:56 CST