Mark_Co
asked on
Learning how to use Virtual Box Oracle SQL Developer... Trying to create package
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
Any suggestions?
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
Any suggestions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And what is the error?
ASKER
Error(20,1): PLS-00103: Encountered the symbol "/"
ASKER
So I remove the "/" and the next error is Error(22,1): PLS-00103: Encountered the symbol "CREATE"
That is not a tool that I am familiar with, but based on the errors that you are getting, it would seem that you cannot combine the package header and body into one script with that tool.
ASKER
I figured. Hmmm, I'll keep trying and seeing how I can get them into separate files but still connected to each other. At work, PL/SQL Developer auto creates a spec and a body file. I don't know how to do so in Virtual box Oracle SQL Developer
virtual box shouldn't be relevant. in what way is it impacting you?
I use virtual box for several different types of servers and once logged in, the virtual nature of my system is invisible to my applications.
I use virtual box for several different types of servers and once logged in, the virtual nature of my system is invisible to my applications.
ASKER
I want to use it for home practice. But it's pretty useless if I can't figure out how to create packages and procedures on it
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I guess it's just virtualbox that has issues. Thanks for trying
how does virtual box figure into this? I'm willing to try to help but you need to tell me what you're doing. What are the errors? What happens? What is leading you to think virtualbox is having a problem? What are you doing differently than what I have above?
why the B?
a penalty grade is not appropriate here
a penalty grade is not appropriate here
ASKER
Open in new window
etc...