tojo wrote:
>>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.
>
exp/imp would exit on a shell, and it would not do what i want. i HAVE
to use pl/sql.
can this not be done in pl/sql?
if not, i think it's a big limitation of oracle.
Received on Wed Oct 09 2002 - 03:26:47 CDT
