Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Justin.langham
Starting Member
2 Posts |
 Posted - 2012-07-30 : 21:10:00
|
| This is the first time that I'm completely stumped by a school assignment, but I think something is missing. However I'm unable to find a starting ground. If someone could point me in a good direction or if they have some information on this type of topic. Ive search my book and I can find anything that cover all steps.This is the question.This assignment allows you to pick your own subject in which you Code a Package Header that contains the following: Global Variable Specification Type Four (4) Procedure Specifications Two (2) Function SpecificationsSubmit your code in a series of Notepad or Wordpad documents. Include the code for the assignment and the output that is realized from running the code. Note: You are responsible for creating the database on which the project will run. This includes the responsibility for loading the database with sufficient data.Grading for this assignment will be based on answer quality, logic/organization of the project to include the compilation, and execution of the project code. |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2012-07-30 : 22:50:33
|
| Sounds like Oracle from the terms you are using.Basically a package header is the Oracle version of a C++ header or Java/C# interface definition.create or replace package my_packageasprocedure p1;procedure p2(params...)function blah (..) returns date;end;I won't clutter the forum with this as it's a SQL Server forum but hopefully that will help you find more.Of course the most correct answer is to ask your teacher. It's been a while since I was at school but they are there to help you, not catch you out. If you don't understand what you are supposed to do then simply get clarification. |
 |
|
|
Justin.langham
Starting Member
2 Posts |
Posted - 2012-07-30 : 23:00:56
|
| Well thank you that actually helps, I did ask my professor but she hasn’t responded yet. The class is PL/SQL Program Units. See I was thinking it was like the header of a file. With the author version description and what not. |
|
|
|
|
|
|
School Assignment.....