Re: create package

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Tue, 8 Oct 2002 12:25:50 -0700
Message-ID: <anvbde$e0u$1@spiney.sierra.com>

S. Bakker's right.

bad systems practice.

create your package (and create table scripts and create trigger scripts and create synonym scripts and grant privs scripts, etc) as a text file and execute it from the sql> prompt.

you should only need them when rebuilding your database after failing to make good backups.

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:o796qugemulitmk94t2pbbc6khilf6qf8q_at_4ax.com...
> On Tue, 08 Oct 2002 17:16:25 GMT, S2 <email_at_mail.com> wrote:
>
> >but anyway, why shuld they complain if i create a package on the fly?
>
>
> Because the database is out of control when package are created on the
> fly. One day you'll agree with me. Hopefully you still have hair on
> that day.
>
>
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Oct 08 2002 - 14:25:50 CDT