Re: Two problems with Oracle and sequences

On Tue, 6 Sep 2005 17:14:23 -0600, Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> wrote:

> The proper fix is to add database-sequence-last to
> db-oracle/oracle-sql.lisp. I don't have an oracle server currently
> available to me.
>
> Given the definition of database-sequence-next in oracle-sql.lisp, I'd
> guess the proper function would be something like the below[1].
>
> Would you mind testing that function and seeing if my sql syntax
> guess is correct?

It works if you replace LASTVAL with CURRVAL.

If you now execute my example you get

  ORA-08002: sequence FOO42.CURRVAL is not yet defined in this session

which is correct behaviour as far as Oracle is concerned.

Thanks for the quick fix,
Edi.

PS: While debugging this I noticed that after executing the form
    (START-SQL-RECORDING) not all SQL commands are recording, the
    sequence commands being amongst them.  Is this an oversight or are
    certain commands not recorded on purpose?  (I personally think for
    debugging it'd be nice if /everything/ was recorded.)