using sequences in DBIx::Recordset

[Steven]

The support for sequences in DBIx::Recordset is only touched briefly in its
documentation. Although I can use sequences, I don't know how the find out
which sequence number was created. I'm using the following environment:

- Oracle 8.1.6 for Linux
- Apache-1.3.17
- modperl-1.25
- embperl-1.3.1
- DBI-1.1.14
- DBD-Oracle-1.06
- ApacheDBI-0.88
- DBIx-Recordset-0.23
- (DBIx-OracleSequence-0.03)

While I can indeed insert a row with a new sequence number for the primary
key, I don't know how to find out which sequence number was used.

I'm using the following code (the $dsn has been set before):
%sqlquery = (
    '!Table'            => 'servicetransactions',
    '!Serial'           => 'ServiceTransactionID',
    '!Sequence'     => 'ServiceTransactionIDSequence',
    '!Fields'       => 'ServiceTransactionID, IntervalBegin, IntervalEnd',
    'IntervalBegin' => $IntervalBegin,
    'IntervalEnd'       => $IntervalEnd
);

*set = DBIx::Recordset -> Insert ({%sqlquery});

Ofcourse I could use DBIx-OracleSequence but as support for sequences is
available in DBIx::Recordset I would like to minimize the number of modules
that are required for my web-site.

- Steven