I imagine the tables are pre-created, that is they don't get created in code
as well. If so it really sould be part of the app install to create the
sequence (and an associated trigger/primary key combo) which the app then
uses.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Gert Brinkmann" <gbrinkmann_at_dimedis.de> wrote in message
news:3C8336D8.A0CE2D85_at_dimedis.de...
> Mark D Powell wrote:
>
> > Gert, a CREATE statement of any type is a DDL statemenat and all DDL
> > statements implicitly commit before and after they execute.
>
> Ok, thanks for all the answers. This is good to know.
>
> > Why would you be creating a sequence inside a transaction, anyway?
>
> Well, we have a database-abstraction-layer that e.g. handles
> serial-columns. In the case of an oracle-DB it is tried to find a
> fitting sequence for the current table. If none is found (the first time
> it is tried) a squence is created for this table. (we do only have one
> serial-column per table.)
>
> Ciao and thanks,
>
> Gert
Received on Tue Mar 05 2002 - 15:03:12 CST
