I need to truncate a table in a procedure and then insert data into the table.
We have a procedure which is used to truncate the table rather than using the TRUNCATE command. I read that, sometimes the truncate table poses a problem when used in a procedure. Is it the same with calling a procedure in the procedure which actually truncates the table?
And how do I call that procedure? Is it as shown below-
Can someone please let me know?
Thanks in advance.