在oracle数据库中同时运行相关或相同的程序，以避免相互干扰。

I have a software for creating especial reports that run procedures in oracle database but the problem is: when we create a report it uses some procedures and truncate and fill some tables, if we create another report at the same time it caused an error because it needs my table information that are truncated with another procedure. So I am looking for a technique or query to handle this problem and create the second report just after the first report finishing all the procedures that it use in the state that user do not notice anything. In this case the time that the second report is going to be create is more than the first report that it is alright.I have a software for creating especial reports