Re: passing PL/SQL variables to SQL PLUS
From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Tue, 02 Apr 2002 22:27:28 GMT
Message-ID: <3CAA2F80.6D3EC5A5_at_shaw.ca>
BEGIN
SELECT MAX(id) INTO v_id FROM names;
v_id := v_id+1;
INSERT INTO names VALUES (v_id,v_first_name,v_last_name); END;
/
Date: Tue, 02 Apr 2002 22:27:28 GMT
Message-ID: <3CAA2F80.6D3EC5A5_at_shaw.ca>
Try this (as an alternative to a before insert row level trigger):
ACCEPT firstName prompt 'Enter the first name: ' ACCEPT lastName prompt 'Enter last name: ' DECLARE
v_first_name names.first_name%TYPE := UPPER('&first_name');
v_last_name names.last_name%TYPE := UPPER('&last_name');
v_id names.id%TYPE;
BEGIN
SELECT MAX(id) INTO v_id FROM names;
v_id := v_id+1;
INSERT INTO names VALUES (v_id,v_first_name,v_last_name); END;
/
hth
Bricklen Received on Wed Apr 03 2002 - 00:27:28 CEST