Re: DBIx::Class and Oracle sequences

Check out DBIx::Class::Storage::DBI::Oracle::Generic. I think you need auto_nextval. I don't have Oracle to test on so this is untested-

__PACKAGE__->add_columns(id => { data_type => 'integer',
                                 size => 16,
                                 sequence => "stream_seq",
                                 auto_nextval => 1 },
              ...
[download]

(update: fixed bad link.)

Comment on Re: DBIx::Class and Oracle sequences Select or Download Code

Replies are listed 'Best First'.
Re^2: DBIx::Class and Oracle sequences by c8h10n4o2 (Initiate) on Aug 24, 2009 at 20:11 UTC
OK, after working with what I provided, I realized the usage of both sequence & auto_nextval caused a double increment. Therefore, remove teh auto_nextval => 1 from above: `__PACKAGE__->add_columns( "id", { data_type => "NUMBER", default_value => undef, is_nullable => 0, size => 126, sequence => "seq_application_id" } );` [download]	[reply] [d/l]
Re^2: DBIx::Class and Oracle sequences by Anonymous Monk on Aug 24, 2009 at 19:15 UTC
once you create your sequence & trigger, use the following: `__PACKAGE__->add_columns( "id", { data_type => "NUMBER", default_value => undef, is_nullable => 0, size => 126, sequence => "seq_application_id", auto_nextval => 1 } );` [download]	[reply] [d/l]
Re^3: DBIx::Class and Oracle sequences by c8h10n4o2 (Initiate) on Aug 24, 2009 at 19:18 UTC
new member so if i posted this twice, i apologize. once you create your sequence & trigger, use the following: `__PACKAGE__->add_columns( "id", { data_type => "NUMBER", default_value => undef, is_nullable => 0, size => 126, sequence => "seq_application_id", auto_nextval => 1 } );` [download]	[reply] [d/l]