Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sequence and Oracle ODBC 8.01.07.00 driver problem

Re: Sequence and Oracle ODBC 8.01.07.00 driver problem

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Fri, 8 Feb 2002 19:01:20 +0100
Message-ID: <PM0003997DFA57BA17@hades.none.local>


Emiliano Antonello wrote:
>
> 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.
>
> How can I resolve this? Thanks.
>

Hello Emiliano,
have you tried a stored function that calls the remote sequence? This ist just an idea and not tested but I think it has a chance to work.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Fri Feb 08 2002 - 12:01:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US