APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop index in a procedure

Pete88Dec 6 2008 — edited Dec 6 2008

Hello

I wish to drop or rebuild a index from a procedure... this procedure will be run nighly in a batch job.

The commands I used from SQLPLUS are

Drop index fred1
or
alter index fred1 rebuild

All is well doing this

If I add them to a procedure

Declase
Begin
Drop index fred1;
fred;

It does not work

Can anyone let know what I am doing wrong?

Thanks

Pete

This post has been answered by Roel Hartman on Dec 6 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2009

Added on Dec 6 2008

#apex-discussions

5 comments

2,090 views