Hi all

I need to create a produce this produce should drop certain table

How can i use drop command in producre

CREATE OR REPLACE PROCEDURE testProc IS
  s_sql    VARCHAR2(500);
BEGIN
  s_sql := 'DROP TABLE mytest';
  EXECUTE IMMEDIATE s_sql;

  s_sql := 'CREATE TABLE mytest AS SELECT * FROM all_tables';
  EXECUTE IMMEDIATE s_sql;

EXCEPTION
  -- Use this to trap the ORA-00942: table or view does not exist
  WHEN OTHERS THEN
      NULL;
end testProc;
/

السلام عليكم

Dear osamazx

Contact system OR SYS AND

GRANT CREATE ANY TABLE
TO MY_USER
/
GRANT DROP ANY TABLE
TO MY_USER

I KNOW THEN MY_USER IS HAVE THIS privileges BUT THE Dynamic SQL MUST BY HAVE specification privileges

نسالك الدعاء

thank you mustafa very much