i have the code :

create table Input_t(
Input_Text varchar2(200)
);

-- 3. create the Topic_Keywords table

CREATE TYPE Top_Key_Type AS OBJECT
( option1 VARCHAR2(80),
option2 VARCHAR2(80),
option3 VARCHAR2(80),
option4 VARCHAR2(80),
option5 VARCHAR2(80),
option6 VARCHAR2(80)
);
/

create table Top_Key(
Key_Topic_ID varchar2(50) primary key, -- Key_Topic_ID is the primary key
Topic_Keyword Top_Key_Type,
Topic_Keyword_Counter number
);

-- 4. create the Topic_Results table

create table Top_Res(
special_Topic_id NUMBER(10) PRIMARY KEY, -- special_Topic_id is the primary key
Topic_Result_ID varchar2(50),
Topic_Result_Counter number
);



DECLARE
PROCEDURE inboxToTopKey (p_input_text IN VARCHAR2,
p_option IN VARCHAR2,
p_key_topic_id IN VARCHAR2,
p_counter IN NUMBER) IS
BEGIN
IF INSTR(p_input_text, p_option) > 0 THEN
INSERT INTO top_res (special_Topic_id, topic_result_id, topic_result_counter)
VALUES (top_res_seq.NEXTVAL, p_key_topic_id, p_counter);
else
INSERT INTO top_res (special_Topic_id, topic_result_id, topic_result_counter)
VALUES (top_res_seq.NEXTVAL,'notda', 0);
END IF;
END;
BEGIN
<< input_t_loop >>
FOR cur_text IN (SELECT * FROM input_t) LOOP
<< top_key_loop >>
FOR cur_tk IN (SELECT * from top_key) LOOP
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option1, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option2, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option3, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option4, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option5, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
inboxToTopKey(cur_text.input_text, cur_tk.topic_keyword.option6, cur_tk.key_topic_id,
cur_tk.topic_keyword_counter);
END LOOP top_key_loop;
END LOOP input_t_loop;
END;
/

insert into it(Input_Text) values
('who is rangers manager');

-- 2. Input tkt

insert into
tkt
values (
't-motherwell',
Top_Key_Type('motherwell', 'administration', 'lanark', 'butcher', 'fir' , 'fadden'),
2
);

the problem is that the part of code:

else
INSERT INTO top_res (special_Topic_id, topic_result_id, topic_result_counter)
VALUES (top_res_seq.NEXTVAL,'notda', 0);

when there is a sentence that doesn't have a keyword in it. i wanted to just put 1 value in
the top_res table but this bit of code puts asmany enteries in as there are lines in my tkt
table.

is there any way to put just 1 entrie in ?