PLS-00905: object HODBA.TRUNC_TABLE is invalid

CREATE OR REPLACE PROCEDURE TRUNC_TABLE(TABLE_NAME VARCHAR2) IS
SQL_STATEMENT VARCHAR2(100);
BEGIN
SQL_STATEMENT := 'TRUNCATE TABLE ' || TABLE_NAME;
EXECUTE IMMEDIATE SQL_STATEMENT;
END;

/

SELECT * FROM TB2
ORA-06550: line 2, column 7:
PLS-00905: object HODBA.TRUNC_TABLE is invalid
ORA-06550: line 2, column 7:
PL/SQL: Statement ignored

***********************************************

You can run the SHOW ERROR command to view the errors as follows:
SQL>show error procedure TRUNC_TABLE;
Errors for PROCEDURE HODBA.TRUNC_TABLE:

LINE/COL ERROR
-------- -------------------------------------------------------------------
7/2 PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.

 

Action:

DELETE THE symbol /

带/表示在PLSQL developer的command下运行，sql不需要/

SQL> exec trunc_table('tb2');
PL/SQL procedure successfully completed