Re: DDL in stored procedures?

From: Jacob Steen Due <jcd_at_ramboll.dk>
Date: 1997/06/04
Message-ID: <33950132.6C88@ramboll.dk>#1/1

Lisa M. Lewis wrote:
>
> I am trying to recreate an index inside a stored procedure. Can anyone
> tell me if this is allowed. Is any DDL allowed inside of stored
> procedures?
>
> Thanks in advance!
>
> Lisa

Hi !

Use the DBMS_SQL package to create the index - normally PL/SQL cannot contain
DDL because the RDBMS wants to ensure the validity of the PL/SQL and DDL statements makes that difficult to say the least.

However using dynamic SQL with the DBMS_SQL package is OK.

Hope this helps.

/Jacob

---

Jacob Steen Due						   email: jcd_at_ramboll.dk
Oracle DBA and application developer                         web:

www.ramboll.dk
RAMBOLL
Teknikerbyen 19
DK-2830 Denmark Received on Wed Jun 04 1997 - 00:00:00 CDT