24: Procedure truncate_table(
25: p_table_name IN VARCHAR2)
26: IS
27: l_num_of_rows NUMBER;
28: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
29: l_statement VARCHAR2(200);
30: Begin
31: l_statement := 'truncate table '||p_table_name;
32: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
28: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
29: l_statement VARCHAR2(200);
30: Begin
31: l_statement := 'truncate table '||p_table_name;
32: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
33: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
34: dbms_sql.close_cursor(l_truncate_handle);
35: Exception
36: When Others Then
29: l_statement VARCHAR2(200);
30: Begin
31: l_statement := 'truncate table '||p_table_name;
32: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
33: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
34: dbms_sql.close_cursor(l_truncate_handle);
35: Exception
36: When Others Then
37: Null;
30: Begin
31: l_statement := 'truncate table '||p_table_name;
32: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
33: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
34: dbms_sql.close_cursor(l_truncate_handle);
35: Exception
36: When Others Then
37: Null;
38: End truncate_table;