The issue is that: There is only one process in running. I am sure there is no other people running the code at the same time. The weird thing is that: at one time, I run the code, it works. Then, run another time, it doesn't work, then run another time, it works again. It seems that the code works 80% times when I run, but fails 20% times when I run it. Either work or fail does happen randomly. Is it possible the code "INSERT INTO sourcing_chart_name10_stad VALUES('ABC_Plant') ;" sometimes executes even before when the code "CREATE TABLE sourcing_chart_name10_stad (chart_name char(30)) ;" is completely done?
... View more