procedure created but not executing
<pre><code>create or replace procedure para_cursor_exe as 
cursor c_p_det(tar_val number) is select name, salary from fees where salary &lt; tar_val;
nname varchar2(30);
ssalary number(5);

begin 
&lt;&lt;block_exe&gt;&gt;
begin
Open c_p_det(&amp;tar_val);
LOOP
FETCH c_p_det into nname, ssalary;
DBMS_OUTPUT.PUT_LINE('NAME : ' || NNAME || ' :::: SALARY : ' || SSALARY);
EXIT WHEN C_P_DET%NOTFOUND;
END LOOP;
CLOSE C_P_DET;
end;

execute immediate ' block_exe ' ;
dbms_output.put_line('done processing !!');

end;
/  

SQL&gt; @para_cursor_exe.sql;
Enter value for tar_val: 1000
old   9:  Open c_p_det(&amp;tar_val);
new   9:  Open c_p_det(1000);

Procedure created.
</code></pre>

<p>The procedure is compiled but on call gives an error as follows </p>

<pre><code>SQL&gt; call para_cursor_exe;
call para_cursor_exe
 *
ERROR at line 1:
ORA-06576: not a valid function or procedure name
</code></pre>

<p>i wanna process the procedure dynamically for different target values which are supposed to be passed to the cursor at runtime. How do i call it or is the logic wrong?</p>