Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: whenever sqlerror is an unknown statement?

Re: whenever sqlerror is an unknown statement?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 25 Jan 2006 21:14:49 +0000
Message-ID: <8cqft1h6e27ufqrplqkl9raov0gtsmkrqr@4ax.com>


On Wed, 25 Jan 2006 10:28:23 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>2. Creating a table in any PL/SQL is deplorable.

 ... if it's application code modifying its own schema. The exception to this rule is if it's actually the installer for the application, that's setting up or upgrading the schema for a new version of a packaged application, where constructs like this have their uses.

 (But it sounds from a later post by the OP that it _is_ application code, so yes it's bad)

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Received on Wed Jan 25 2006 - 15:14:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US