| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DROP tables in PL/SQL
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
 |
 |