PL/SQL error checking
From: Terminal Booking Project <termbook_at_guinevere.st.nepean.uws.edu.au>
Date: 27 Apr 1994 18:58:32 +1000
Message-ID: <termbook.767436955_at_lancelot.st.nepean.uws.edu.au>
Date: 27 Apr 1994 18:58:32 +1000
Message-ID: <termbook.767436955_at_lancelot.st.nepean.uws.edu.au>
We have a PL/SQL block that requires certain error checking to be done, however
we are not sure exactly how to go about doing it.Our code currently looks like:
BEGIN
insert into terminal
values ('&terminal_no','&room_no','&type','&name');
IF name != 'termbook' THEN
name = 'XXXXXXXX';
ENDIF;
exit;
END;
/
Does anyone have any suggestions on how to resolve this. Termbook Group. Received on Wed Apr 27 1994 - 10:58:32 CEST