PL/SQL (MOSC)

MOSC Banner

Oracle Package Procedure not executing correctly

in PL/SQL (MOSC) 10 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center