Re: pl/sql alter index
From: Kerry Scott <kerrysco_at_ameritech.net>
Date: Tue, 27 Mar 2001 16:44:09 -0500
Message-ID: <pP7w6.30$O25.4614_at_nntp0.chicago.il.ameritech.net>
Date: Tue, 27 Mar 2001 16:44:09 -0500
Message-ID: <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 Tue Mar 27 2001 - 23:44:09 CEST