Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Anthony Williams wrote: > Tony Hoyle <tony.hoyle at march-hare.com> writes: > >> Luigi D. Sandon wrote: >>>> little harder that's all since it needs to modify the insert statement. >>> No need to modify the insert statement if the sequence is used in a before >>> insert trigger. You get the same behaviour of an autoinc column. >>> >> The issue then becomes retrieving that value - unless the trigger can force >> the insert to return it somehow. > > I posted a selection of alternatives that work with Oracle yesterday. > > Have my posts to the newsgroup not been getting through? > > Anthony Unless this is what you are talking about I haven't seen it on the mailing list. <snip Anthony Williams wrote: Oracle provides INSERT .... RETURNING (someColumn) INTO :someBindVariable for precisely this purpose. Oracle also has sequences rather than auto-increment columns. </snip> Cheers Mikew