I'm looking at a package that someone who is no longer with us wrote. It is full of EXECUTE IMMEDIATE staements that are running SQL commands that could easily have been written as static SQL, sometimes with bind variables that are currently being concatenated into the text to be executed.
Questions for you all: Is there some advantage to running dynamic SQL under certain circumstances? I don't think there is, but then... Were there some myths back in the past about dynamic vs. static that might have caused my predecessor to do this?
Just trying to decide if I should leave the code alone.