DA Morgan wrote:
> kevx wrote:
>> sybrandb_at_gmail.com wrote:
>>> On Fri, 23 Mar 2007 22:13:09 -0400, roadrunner <kevx_at_tampabay.rr.com>
>>> wrote:
>>>
>>>> Help! I have a final due tomorrow and suddenly they throw in a
>>>> problem that requires end user input, which we've never covered.
>>>> They give a hint but it doesn't help much.
>>>>
>>>> Here's what is required:
>>>> 1.0 Employee Master File/Table
>>>> 1.1 Design the Employee Table using the following table
>>>> specifications (10 Points)
>>>>
>>>> Field Name Data Type Description
>>>> Employee_Code Text Primary Key
>>>> Employee_SSN Text Social Security Number
>>>> First_Name Text Employee First Name
>>>> Last_Name Text Employee Last Name
>>>> Employee_Doe Date Employee Date of Employment
>>>> Employee_Dpt Text Employee Department
>>>> Hourly_Rate Currency Employee Wage Hourly Rate
>>>> Annual_Salary Currency Employee Annual Salary
>>>>
>>>> 1.2 Create a BERFORE INSERT trigger that will compute both the
>>>> Employee Code
>>>> and the Annual Salary. Include your program source code with your
>>>> documentation. (70 Points)
>>>>
>>>> 1.3 Write a PL/SQL program that will prompt the end-user to enter
>>>> some of the
>>>> values of the Fields in step 1.1 above. Include your program source
>>>> code with your documentation. (70 Points)
>>>>
>>>> Example:
>>>> Enter Value for Employee First Name………………..…… John
>>>> Enter Value for Employee Last Name…………………...… David
>>>> Enter Value for Employee SSN……………………............. 123456789
>>>> Enter Value for Employee Employment Date……............... 12/12/2005
>>>> Enter Value for Employee Department Name…………….. Engineering
>>>> Enter Value for Employee Hourly Rate…………………… 20.50
>>>>
>>>> a. After the end-user has finished inputting the above data for
>>>> an employee, the PL/SQL program will automatically insert the record
>>>> into the employee Master Table.
>>>>
>>>> b. This record insertion action will trigger a BERFORE INSERT
>>>> Trigger which will compute both the Employee Code and the Annual Salary
>>>>
>>>> Here is the hint that they give:
>>>>
>>>>
>>>> SET SERVEROUTPUT ON FEEDBACK OFF
>>>> DECLARE
>>>> EmployeeFirstName VARCHAR2(25);
>>>> BEGIN
>>>> EmployeeFirstName := &Employee_First_Name;
>>>> EXCEPTION
>>>> WHEN OTHERS THEN
>>>> NULL;
>>>>
>>>> END;
>>>>
>>>> Running this gives this error:
>>>>
>>>> ERROR at line 4:
>>>> ORA-06550: line 4, column 24:
>>>> PLS-00201: identifier 'JO' must be declared
>>>> ORA-06550: line 4, column 3:
>>>> PL/SQL: Statement ignored
>>>>
>>>> Huh? The variable is now named JOE instead of containing Joe? Am I
>>>> doing something wrong? Wow I'm so bummed over this because I know
>>>> what to do once I have this but can't figure it out. Anyone?
>>>
>>> The code provided is incorrect. If you still don't know how to address
>>> this, you deserve to fail the final. You don't deserve to succeed the
>>> final by cheating, by getting help from this forum.
>>> In the big world out there nobody will hold your hand.
>>>
>> What a jerk. Seeking the answer is not cheating.
>
> Yes it is. I have a small amount of subject matter expertise on this
> one and the OP's claim that something was "thrown at the last minute"
> doesn't hold water and doesn't matter.
>
> Asking for hints is acceptable. Asking where to find documentation
> is acceptable. Asking for the answer is cheating.
>
> All I needed to read was "final due tomorrow" and I knew this student
> had been, proverbially speaking, out drinking beer when others were
> studying.
>
> The help I'll offer ... learn from the experience.
I repeat, no one was asking for the answer; you made an assumption.
maybe you should have taken more than that "one look" at post. As for
the "out drinking" remark, would you care to see the class bulletin
board on which most of the students are collaborating on trying to
figure out these problems? TSK. TSK.
Received on Sat Mar 24 2007 - 15:37:05 CDT
