Re: create package

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 08 Oct 2002 19:06:12 +0200
Message-ID: <p046quk9fnjrsva22ejth029pgretpu529@4ax.com>

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. Also you won't make with friends with administrators if you are doing so.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 08 2002 - 12:06:12 CDT