[cvsnt] Re: Repository auditing with Oracle
Mike Wake
mike.wake at thalesgroup.com
Wed Jan 11 13:39:14 GMT 2006
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
More information about the cvsnt
mailing list