RE: How can I get insert_id from DBD::Oracle?

[Rich Buckley]

All,

Using a sequence and trigger as discussed will allow the following
to work :

        INSERT  INTO    tab     (value) VALUES ('foo');
        SELECT  MAX(id) FROM tab;

as long as these two statements are within the same transaction
block.

I do however like the Oracle 8 returning clause a lot.

--Rich