Re: create statement inside a PL/SQL block?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 05 Jun 2002 19:11:22 GMT
Message-ID: <3CFE6253.10A8FF62@exesolutions.com>

Sybrand Bakker wrote:

> On Wed, 5 Jun 2002 20:19:47 +0200, Jan Eliasen <jan_at_eliasen.dk> wrote:
>
> >Hi there.
> >
> >I can't seem to create an index when inside a PL/SQL block, can that be
> >true? If so, is there a workaround?
> >
> >I am running Oracle9i on a Redhat 7.2 Linux machine.
> >
> >Thanks in advance.
>
> Study (the execute immediate statement in) your pl/sql documentation
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

And after you do that seriously reconsider why you would want to. This is generally, though not always, a sign of a lack of critical thinking about an application during the design phase.

Daniel Morgan Received on Wed Jun 05 2002 - 14:11:22 CDT