Help in a simple procedure

[ali560045]

i want to develope a pl/sql procedure that will create an empty table. below the code that i wrote but it is not working

create procedure myProc AS
declare 
	first_name    VARCHAR(15),
         	last_name     VARCHAR(15),
         	salary        FLOAT(8,2),
         	city          VARCHAR(10),
        	description   VARCHAR(15)
BEGIN
EXECUTE IMMEDIATE ('create table employee_table');
END;

[davey23uk]

why did you think it would work - that isnt a correct create table statement

[ali560045]

Thank you sir for pointing that out. I m very new to Sql procedure can you tell/show me the correct syntax for the above code

[mahajanakhil198]

create table
( first_name VARCHAR(15),
last_name VARCHAR(15),
salary FLOAT(8,2),
city VARCHAR(10),
description VARCHAR(15)
);

[ali560045]

u didnt get me i want to know how to create empty table using sql procedure and not using sql query....

[PAVB]

Well... your procedure has to:

1) Be able to get all data it needs -owner, table_name, column_names, column_attributes, etc - as input parameters
2) Build a proper create table statement on the fly -dynamic sql
3) Execute such an statement

[davey23uk]

create table
( first_name VARCHAR(15),
last_name VARCHAR(15),
salary FLOAT(8,2),
city VARCHAR(10),
description VARCHAR(15)
);

what the hell is that?

[gtcol]

create table employee_table
( first_name VARCHAR(15),
last_name VARCHAR(15),
salary number(8,2),
city VARCHAR(10),
description VARCHAR(15)
);

or
BEGIN
EXECUTE IMMEDIATE '
create table employee_table
(
first_name VARCHAR(15),
last_name VARCHAR(15),
salary number(8,2),
city VARCHAR(10),
description VARCHAR(15)
)';
END;
or
create procedure myProc AS
BEGIN
EXECUTE IMMEDIATE '
create table employee_table
(
first_name VARCHAR(15),
last_name VARCHAR(15),
salary number(8,2),
city VARCHAR(10),
description VARCHAR(15)
)';
END;

Lots of ways there. You can't just give table structure that way.