SQL & PL/SQL

Hello all,

Iam having below SQL query in file "main .sql ". For user input line_number it has to display the results.
User will be entering multiple line numbers and for each new line number he shoulnd not execute again "main.sql". this task has to be repititive untill he exits. This has to be done only in SQL query.

Please help me how can we achieve this

ACCEPT line_number -
PROMPT "Enter line number: "

SELECT ROWNUM,line_detail_id, quantity,
STATUS,EXPECTED_RECEIPT_DATE
FROM sgp_user_supply
WHERE line_detail_id =&line_number;

And also i have another doubt can we call "main .sql " query and display at runtime from a pl/sql block.

Regards,
Kiran