Re: College finals help! End User input in PL/SQL?

roadrunner <kevx@xxxxxxxxxxxxxxx> wrote in news:46058a56$0$27093
$4c368faf@xxxxxxxxxxxxxx:

Ana C. Dent wrote:
kevx <camarosxs@xxxxxxxxxxxxxxxx> wrote in
news:4604f7ec$0$4851$4c368faf@xxxxxxxxxxxxxx:

sybrandb@xxxxxxxxx wrote:
On Fri, 23 Mar 2007 22:13:09 -0400, roadrunner
<kevx@xxxxxxxxxxxxxxx>
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!

.

Relevant Pages

  • Re: College finals help! End User input in PL/SQL?
    ... They give a hint but it doesn't help much. ... Employee Master File/Table ... Include your program source code with your ... Seeking the answer is not cheating. ...
    (comp.databases.oracle.misc)
  • Re: College finals help! End User input in PL/SQL?
    ... They give a hint but it doesn't help much. ... Design the Employee Table using the following table specifications ... Include your program source code with your documentation. ... Seeking the answer is not cheating. ...
    (comp.databases.oracle.misc)
  • Re: College finals help! End User input in PL/SQL?
    ... They give a hint but it doesn't help much. ... Employee Master File/Table ... Include your program source code with your documentation. ... Seeking the answer is not cheating. ...
    (comp.databases.oracle.misc)
  • Re: Filter data within a column
    ... Link each of these commands to the employee master table as an outer join on ... you are adding selections to the pay components database they'll ... line per employee code, so the details section is useable. ... > Pay Components are Basic, HRA, TA ...
    (microsoft.public.vb.crystal)
  • Re: Get corresponding column value
    ... This property can be used to store arbitrary data. ... If employee's select resultset is not large, ... into a data structure (dictionary with employee code as key) and put that ... R> retrieve employee first and last name when a user selects an employee ...
    (microsoft.public.dotnet.languages.csharp)