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

Home -> Community -> Usenet -> c.d.o.server -> Re: DROP tables in PL/SQL

Re: DROP tables in PL/SQL

From: Louis <zeroadmin_at_gmail.com>
Date: 29 Nov 2005 07:41:03 -0800
Message-ID: <1133278862.973460.145120@z14g2000cwz.googlegroups.com>


rule for the dumb. Never DDL in stored procedures. even don't do the dynamic sql trick. You lose the power of compiled sql this way.
You will get errors on your system only at runtime, you most certainly want the errors at compile time, and not when your code jewel is running on production. I read this rule in PL/SQL Feuresteins book (o'reilly), it's a life saver.
Louis Received on Tue Nov 29 2005 - 09:41:03 CST

Original text of this message

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