Re: create/using type dynamically

"hitchhikar" <reachsonu_at_gmail.com> wrote in message news:1141454311.546785.27490_at_j33g2000cwa.googlegroups.com...
> Ok Jim..the scenario is that i have to serialize an object in DB. This
> object has 100+ key-value pair. One key has got more then one value. To
> be backward compatible(for exsistin reporting system) i have to store
> the keys informations in their separate tables.These table contains
> around a million of record at a given time.
> Keys can be added to my object from the user at runtime. I create a new
> table for a new key and stores its value there.
> This whole has to be done as a single unit..i mean transaction.
> So the problem is what is the most (oracle)efficient way to achieve
> this.
>

If you create a type dynamically (not a real good idea, but it can be done) then it will issue a commit for you so there goes your transaction boundary. (DDL always commits) You still haven't stated what the business problem is, you have stated a solution to some sort of business problem. If I read between the lines I fear you have created a monster in bad programming practices and design. But who knows, we don't know what the problem you are trying to solve is. Without going into the solution state the problem. Jim Received on Sat Mar 04 2006 - 16:18:30 CST