非常簡單的一個PROCEDURE，COMPILER 也OK，但是一執行就會有 錯誤 ORA-00903: invalid table name TABLE真的存在，為何說INVALID呢?CREATE OR REPLACE PROCEDURE TEST2
IS
sql_stmt VARCHAR2 (4000);
tablen varchar2(10);
BEGIN
tablen := 'test1';
sql_stmt := 'TRUNCATE TABLE :1';
EXECUTE IMMEDIATE sql_stmt USING tablen ;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
IS
sql_stmt VARCHAR2 (4000);
tablen varchar2(10);
BEGIN
tablen := 'test1';
sql_stmt := 'TRUNCATE TABLE :1';
EXECUTE IMMEDIATE sql_stmt USING tablen ;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
