I don't suppose there's anyway to use the RETURNING clause within Zend_Db's architecture without writing out the full statement myself and using parameter bindings?
I'd expect Zend_Db_Adapter_Abstract::insert() would support something of this nature for Oracle databases. It's probably the only way to easily get back a primary key on tables that are setup to "mimic" auto_increment. On top of that, I'm having one hell of a time battling with our DBAs to gain access to even view the sequence to pop it. (not to mention we have a lot of auto-generated sequences that don't get created until first insert -- please, don't ask. Even some of our current DBAs are baffled). --- Philip [EMAIL PROTECTED] http://www.gpcentre.net/
