Re: DROP in Procedures

From: SteveC <carnwath_at_synygy.com>
Date: 13 Nov 2001 13:01:50 -0800
Message-ID: <cea788de.0111131301.37ab475d_at_posting.google.com>


You probably need to put the statement within an 'execute immediate' statement..

BEGIN
  select * from dual;

  • do some other things

  execute immediate 'drop index myIndex';

  • do some more things

END; "andrija" <ar35644_at_fer.hr> wrote in message news:<9srdj2$3bil$1_at_as201.hinet.hr>...
> How can I drop index in procedure?
Received on Tue Nov 13 2001 - 22:01:50 CET

Original text of this message