I'm trying learn how to use VB and I'm having trouble creating a package on Oracle SQL Developer in Virtual Box.
I go to file -> new -> Package...
then I don't see two separate files (one for spec and one for body) so I tried to insert both spec and body into one file but I keep getting an error, no matter how I try to insert my code for a working package.
I normally use PL/SQL Developer so I know my package already works on there but I can't get it to compile in VB.
I try to compile and because I have both spec and body in one file it is complaining about my "CREATE" that is coming from the body i.e. CREATE OR REPLACE PACKAGE BODY DROP_CREATE_TABLES_NIGHTLY IS