I'm new at using Stored Procedures, and here is my procedure. And I'm using SQL Plus, but I type this in and it just seems to give me a new line when I want the command to end. What do I need to do.

Thanks.


CREATE OR REPLACE PROCEDURE parcel_t1 (
p_CityID ttt.CITY_ID,
p_StreetName ttt.STREET_NAME),

BEGIN
SELECT CITY_ID,STREET_NAME FROM tttt
WHERE CITY_ID = 'TC'
-- Insert a new row in the parcel_t1 table
INSERT INTO parcel_t1 (CityID, Street_Name)
VALUES (CITY_ID, STREET_NAME));

COMMIT;
END parcel_t1;