On Feb 26, 8:43 am, zarnce <[email protected]> wrote: > Is it possible to run an insert command that uses the returning > parameter? I am using Oracle through the JDBC driver. > > INSERT INTO <table_name> > (column_list) > VALUES > (values_list) > RETURNING <value_name> > INTO <variable_name>;
I don't think the Oracle shared adapter currently supports the returning clause. The PostgreSQL and Firebird adapters do. I'll accept a patch to the Oracle adapter, though it may be tricky because the INTO <variable_name> might not be handled the same way by all adapters (i.e. the native oracle adapter may not handle it the same way as the JDBC adapter when connecting to Oracle). You might have to create a Oracle specific JDBC subadapter and just add support there. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
