Oracle allows table creation from stored procedures too.

On Wed, 5 Mar 2003, German Terrazas wrote:

> hi martijn,
>
> You can create tables in SQL Server as many times you want from any
> procedure you write.
>
> I am checking the same feature in Oracle.
>
> thanks,
> german
>
>
> On Wed, 5 Mar 2003, Martijn Tonies wrote:
>
> > Hi German,
> >
> > > The problem is as follows:
> > >
> > > I have a table A with records referencing to a table. The problem I
> > > have is that for any new record of A it is necesary to create a table Aj.
> >
> > Why?
> >
> > > I can obtain the name of the new table by string concatenation and pass
> > > the name to a stored procedure. But, that stored procedure cannot perform
> > > a create table.
> > >
> > > My solution is to pass the createTable query string to a delphi
> > > DB component. I think it is better to reach a more deployment platform
> > > independent solution.
> >
> > Usually, you design your metadata structure and then populate it with data.
> > Metadata is fixed - only when, for example, upgrading your application -
> > this is changed.
> >
> >
> > With regards,
> >
> > Martijn Tonies
> > InterBase Workbench - the developer tool for InterBase & Firebird
> > Firebird Workbench - the developer tool for Firebird
> > Upscene Productions
> > http://www.upscene.com
> >
> > "This is an object-oriented system.
> > If we change anything, the users object."
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>