Re: procedure and ddl commands?

1. look into EXECUTE IMMEDIATE
2. ditto -- just select the value into a variable and use the variable in an expression to construct the CREATE SEQUENCE command, pass the expression to EXECUTE IMMEDIADATE (within a variable or directly)

++ mcs

"dead" <OVOIZBACI-vlasic_at_vodatel.net> wrote in message news:ce2fsg$f77$1_at_sunce.iskon.hr...
| Can someone help me.
| I wolud like to make procedure on server with creating tables, sequences
and
| indexes.
| 1. can I put ddl commands in oracle procedures?
| 2. how to put create sequnce command with 'start with' value as result of
| 'select command' (I need max value +1 from table for next value of
| sequence) in procedure?
|
|
Received on Mon Jul 26 2004 - 07:15:11 CDT