PL/SQL Question

Is it possible to do things like alter tables or create tables within PL/SQL? I tried the following, but keep getting a PLS-00103 error.

BEGIN alter table workqueue_order_doc disable constraint FK_WORKQ_ORDER_DOC_WORKQ_ORDER; create table tmp_workqueue_order as
select *
from rsiplate.workqueue_order
where current_workqueue_folder_id in
( select distinct workqueue_folder_id
from rsiplate.workqueue_workgroup_proflow
);

truncate table workqueue_order;

insert into workqueue_order
(
select *
from tmp_workqueue_order
);

alter table workqueue_order_doc enable constraint FK_WORKQ_ORDER_DOC_WORKQ_ORDER; END; Thanks!

Curtis Received on Wed Jan 19 2005 - 11:04:05 CST