roadrunner <kevx_at_tampabay.rr.com> wrote in news:46058a56$0$27093
$4c368faf_at_roadrunner.com:
> Ana C. Dent wrote:
>> kevx <camarosxs_at_tampabay.rr.coim> wrote in
>> news:4604f7ec$0$4851$4c368faf_at_roadrunner.com:
>>
>>> 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.
>>
>> Using another person's answer is NOT cheating exactly how/why?
>> What is the difference between copying the answer from a person
sitting
>> in the desk/chair next to you on a test than copying the answer from
>> Usenet?
>> In both cases the answer is not really your own.
>> How again is this NOT cheating?
>
>
> This wass an "open-computer" test. Did I ask anyone for the answer?
No,
> I asked for some assistance to point me in the right direction. This
is
> not only allowed in this course, but encouraged. Besides, That is
> exactly what this forum is for. I understand what you thought you were
> encountering, but you were mistaken.
>
You imply that if you could get past getting the data into the PL/SQL,
the rest of the programming task would be a piece of cake for you.
I was always taught that the assignment of a string/characters to a
PL/SQL variable it needed to be enclosed in single quote marks; ie
EmployeeFirstName := 'Dummy';
Since you neglected to provide them; Oracle threw an error & you went
into Chicken Little mode.
I see that this was all the Professor's fault for this out of scope
assignment.
HTH & YMMV!
Received on Sat Mar 24 2007 - 16:22:08 CDT
