santo

• Oct 9th, 2006

 

Ya, we can create table with procedure by using 'EXECUTE IMMEDIATE' command.

Mutating error:- occurs when row level trigger accesses same table on which it is based while executing or the table currently being modified by the DML statements.

rani

• Oct 9th, 2006

 

mutating trigger error number is ORA-04091

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 26th, 2006

 

HI,

  table can be created by using either dbms_sql or EXECUTE_IMMEDIATE in procedure or function.

sankari

• Jan 9th, 2007

 

We can do as shown below... in the same way we can drop the table..



DECLARE

BEGIN




EXECUTE IMMEDIATE 'create table employee(empno number(3),ename varchar2(10))';



END;