Re: Sequences in Oracle with ODBC

From: Joe Brown <joebrownNO_SPAM_me_very_MUCH_at_leading.net>
Date: Thu, 01 Oct 1998 22:24:20 GMT
Message-ID: <36140005.183565633@news.leading.net>

Don't prefix the sequence with sequence and the TAO will ensue.

SQL> select Asequence.nextval from dual

I'm assuming you DO NOT have a schema named sequence, which contains sequence: Asequence.

Is is possible to have a schema named sequence??? I shudder the conSequence

"Jan Driesen" <jan.driesen_at_glo.be> wrote:

> Hi,
>
> I made an ODBC connection to Oracle.
> I can access the tables. (select * from Atable).
> It is not possible to access the sequences (select
> sequence.Asequence.nextval from dual)
>
> Does anyone know to how to retrieve values from a oracle sequence with
> odbc?
>
> Thanks,
>
> From Jan Driesen, jan.driesen_at_glo.be
>

--
joebrown
@leading.net Received on Thu Oct 01 1998 - 17:24:20 CDT