Re: create package

Hi Rauf,

maybe you could use synonyms for interfacing and switch the object behind it,
So you could leave the objects where they are (maybe in another schema) and the synonyms in the working schema.

regards

s.kapitza

S2 <email_at_mail.com> wrote in message news:<3DA3CDCB.5070302_at_mail.com>...
> 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.
Received on Thu Oct 10 2002 - 12:46:40 CDT