I see a couple errors in the code itself. When comparing data in Oracle you place a literal in Single Quotes. Where Name like 'ho%';
Oracle is case sensitive, so take that into consideration when comparing literals.
The cursor attribute you want to check is NOTFOUND.
EXIT WHEN c_test%NOTFOUND;
Remove the underscore you have in NOT_FOUND.
Your code should look like this.
CREATE OR REPLACE PROCEDURE FYP.TEST
CURSOR c_test IS
WHERE name like 'ho%';
FETCH c_test INTO v_name;
EXIT WHEN c_test%NOT_FOUND;
v_count := v_count + 1;
Keep in mind you will want to catch any exceptions and close the cursor if it is still open as mentioned in a previous post. In addition, this procedure will run, but you won't see any output. You could either pass an OUT parameter, or use a DBMS_OUTPUT.PUT_LINE to display your counter to the screen.