Re: Ugent help with Script

C.Lussier wrote:

> I am of course a beginner with Oracle and have a project to complete for
> tomorrow. As I do not have Oracle set-up on my PC at home, I cannot
> verify if this script will run and what errors will be generated. Could
> someone please have a look at this script and tell me if it will run?
> The script should do the following:
> Create a PL/SQL script that will allow a technician to enter line
> details in a service call (assume that the service calls are entered by
> another person ie. a clerk) and that the service_call table is already
> filled by another program.
>
> Here is my script:
> <snip>

> BEGIN
> UPDATE sc_details
> WHERE sc_number = v_sc_number
> AND line_id = v_line_id
> AND part_id = v_line_id
> AND service = v_service
> AND technician = v_technician
> AND hours = v_hours;
> EXCEPTION
<snip>

One thing I noticed is that you are doing an update but not setting anything - that is, you are not adding or changing any data in any columns.

HTH
Geoff Received on Mon Apr 19 1999 - 01:43:08 CDT