Oracle Package Procedure not executing correctly
Working in an Oracle 19c ADW environment. I've worked with Oracle databases and SQL for decades. Only recently started working with Packages/Procedures. Most of my packages work fine. However, I have one procedure that takes in parameters and takes certain actions. The code first checks to see if the table exists and if it does, drops it. Then it creates a physical table from an external table (based on csv files in an object storage environment). The drop works fine, but the create table never creates the new table. When I run