You can't direct DDL command ..
you can use DDL command like that;

begin
EXECUTE IMMEDIATE 'DROP TABLE X;
end;

or

declare
2 c1 binary_integer;
3 begin
4 c1 := dbms_sql.open_cursor;
5 dbms_sql.parse(c1, 'create table test(a number)', dbms_sql.native);
6 dbms_sql.close_cursor(c1);
7 end;
8 /

-----Original Message-----
From: Poole David [mailto:oracledba-ezmlmshield-x83834076.[Email address protected]
Sent: Thursday, April 07, 2005 4:34 PM
To: LazyDBA Discussion
Subject: Forms: Trying to 'DROP TABLE'


Hi Guru

How do I drop a table using Oracle Forms? So far I have the following PL/SQL
in a triggered button but whenever I try to compile it it errors.

All help greatly appreciated.

David

------------------------------------
begin
drop table CALL_BARRING_TEMPLATES;
end;
------------------------------------

Systems Operations, Thus Plc.
.
. . _
www.thus.net www.demon.net
email. david.[Email address protected]
internal. 740 4156
external. 0141 566 4156
mobile. 07880 502093


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 06.04.2005


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 06.04.2005


Oracle LazyDBA home page