How to create table by store procedure in Oracle9i

Hi All !

   How to create table by store procedure in Oracle9i ?

Please help me !

CREATE OR REPLACE procedure New_myproc IS

 VT_Statement varchar2(1000):='CREATE TABLE ATest (USERID NUMBER (14),MAKH VARCHAR2 (15),SOMAY VARCHAR2 (9),DVUID VARCHAR2 (15),TIEN NUMBER (14,2),KYHIEUDVU VARCHAR2 (15))';  VT_cursor integer;
 VT_exe integer;

begin         

	VT_cursor:= dbms_sql.OPEN_CURSOR;
	dbms_sql.PARSE(VT_cursor,VT_Statement,2);
    VT_exe:= dbms_sql.EXECUTE(VT_cursor);	
	dbms_sql.CLOSE_CURSOR(VT_cursor);   
	   

END; This store had one error, but I can't find it. Please help me !
Thanks you very much Received on Tue Jul 08 2003 - 02:51:50 CDT