Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Question
"Curtis" <hystable_at_yahoo.com> a écrit dans le message de
news:1106154245.472707.202240_at_z14g2000cwz.googlegroups.com...
| 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
|
execute immediate 'DDL';
PL/SQL User's Guide and Reference, Chapter 11: Native Dynamic SQL http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/11_dynam.htm#4376
Regards
Michel Cadot
Received on Wed Jan 19 2005 - 11:10:07 CST