Re: pl/sql alter index
Date: Wed, 28 Mar 2001 21:15:36 -0500
Message-ID: <ua$enY$tAHA.351_at_cpmsnbbsa07>
If not using Oracl8i, then use DBMS_SQL package inside PL/SQL code.
"Kerry Scott" <kerrysco_at_ameritech.net> wrote in message
news:pP7w6.30$O25.4614_at_nntp0.chicago.il.ameritech.net...
> If using Oracle8i, then try this:
>
> execute immediate 'alter index whatever...';
>
>
> "Craig Taylor" <crtaylor-is_at_home.com> wrote in message
> news:zMSv6.140388$p66.39952154_at_news3.rdc1.on.home.com...
> > Hi,
> >
> > I have a general question about pl/sql. I have a simple update procedure
> > running on a job queue, but I need the intermedia text index to be
synced
up
> > right afterwards. I can't seem to be able to place the "alter index"
inside
> > a procedure or a job queue. I get a "expecting insert, delete, etc....
at
> > alter". I appreciate any advice or help.
> >
> > Thanks,
> >
> > Craig
> >
> >
>
>
Received on Thu Mar 29 2001 - 04:15:36 CEST