Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create package
In article <3DA3CDCB.5070302_at_mail.com>, email_at_mail.com says...
> Rauf Sarwar wrote:
> Karsten Farell <kfarrell_at_medimpact.com> wrote in message
> news:<vcFo9.1533$zs6.192978065_at_newssvr13.news.prodigy.com>...
>
> > Any reason you cannot use VARCHAR2(32767)??
> no. no reason. i did that. but my packages are greater anyway.
>
>
> > More importantly... Why exactly you want to create a package on the
> > fly?
> i'll try to explain:
> we have a schema a, witch contains some packages that execute statistic
> calculations and other things on some data and parameters stored in
> tables in schema a.
>
> our customers need to "freeze" the state of the schema and restore it
> later on. this is done by copying the rows in the tables to another
> schema, b, and the packages are also saved to schema b, by copying the
> source in a table.
>
> this can be done several times.
>
> we don't want to use sqlplus, because we don't want to exit on a shell.
>
> now we have this scenario: n packages and n parameter/data
> configurations stored in schema b.
>
> the user can now choose one of these n configurations and put them back
> to schema a.
>
> this works for the rows in the tables, but the packages need to be
> restored also, and the limit of 32767 chars is killing me.
>
>
Don't kill yourself, just use export/import.