Sybrand Bakker wrote:
> On Tue, 08 Oct 2002 15:21:00 GMT, S2 <email_at_mail.com> wrote:
>
>
>>hi.
>>
>>i want to dinamically create a package in a pl/sql procedure.
>>to do this, i create a varchar2(4000) variable, write the procedure in
>>it and the execute immediate the variable.
>>
>>my problem is the limit of 4000 chars, because it could be that the
>>package body i want to create with execute immediate is a lot larger
>>than 4000 chars.
>>
>>any solutions?
>>
>>(i work on oracle 9i)
>
>
>
> Redesign your code so you don't need to create a package on the fly.
this is not an option.
> Also you won't make with friends with administrators if you are doing
> so.
i know them personally, and i know where thay live, so they do what i
ask them :)
but anyway, why shuld they complain if i create a package on the fly?
--
regards,
Simon
Received on Tue Oct 08 2002 - 12:16:25 CDT
