October 11th, 2004, 07:31 AM
|
|
Contributing User
|
|
Join Date: May 2004
Posts: 57
Time spent in forums: 18 h 25 m 54 sec
Reputation Power: 5
|
|
|
pl/sql procedure
i am trying to create a procedure in pl/sql.
it's named loenn, which takes a percentage and a staffnumber as arguments.
the percentage tells how much the salary should increase for that staffnumber.
the DBMS_OUTPUT should tell 1 of these:
the row was updated.
the staff does not exist.
the staff has no salery.
Code:
SET SERVEROUTPUT ON
CREATE OR REPLACE PROCEDURE loenn(p_prosent IN NUMBER, p_ansnr IN NUMBER)
IS
ansattEksistererIkke EXCEPTION;
ikkeOppgittLoenn EXCEPTION;
v_loenn ansatt.timeloenn%type;
v_ansnr ansatt.ansnr%type;
BEGIN
SELECT timeloenn, ansnr INTO v_loenn, v_ansnr from ansatt;
UPDATE ansatt SET timeloenn = timeloenn * (1 + p_prosent/100)
WHERE ansnr = p_ansnr;
IF v_loenn = null THEN RAISE ikkeOppgittLoenn; END IF;
IF v_ansnr = null THEN RAISE ansattEksistererIkke; END IF;
DBMS_OUTPUT.PUT_LINE('Raden ble oppdatert');
EXCEPTION
WHEN ansattEksistererIkke THEN
DBMS_OUTPUT.PUT_LINE('Ansatt eksisterer ikke');
WHEN ikkeOppgittLoenn THEN
DBMS_OUTPUT.PUT_LINE('Vedkommende ansatt har ikke oppgitt noen timeloenn');
END loenn;
/
can someone help me?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
