Cerating Table In Procedure

SAMEEN

HELO !
Please HELP me SOON in creating table in procerdure i write the following statment but it gives error
CREATE OR REPLACE
PROCEDURE EMP_BACK_UP_SALARY
(param IN VARCHAR2) AS

BEGIN

CREATE TABLE a AS (SELECT * FROM b);

END;

Error
"Encountered the symbol CREATE while expecting the following like BEGIN CASSE DECLARE ETC"

debasisdas

You need to execute the create table statment with EXECUTE IMMEDIATE.

EX
------

execute immediate 'create table ..............' ;

Cerating Table In Procedure

re: Cerating Table In Procedure

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about