53: Procedure Truncate_table(
54: p_table_name IN VARCHAR2)
55: Is
56: l_num_of_rows NUMBER;
57: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
57: l_truncate_handle PLS_INTEGER := dbms_sql.open_cursor;
58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then
58: l_statement VARCHAR2(200);
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then
66: Null;
59: Begin
60: l_statement := 'truncate table '||p_table_name;
61: dbms_sql.parse(l_truncate_handle, l_statement, dbms_sql.native);
62: l_num_of_rows := dbms_sql.execute(l_truncate_handle);
63: dbms_sql.close_cursor(l_truncate_handle);
64: Exception
65: When Others Then
66: Null;
67: End truncate_table;