There are no EXECUTE server command (some client support this as a client command, wraps the content to execute into an anonymous PL/SQL block and then use that to make the database call).
begin Test_Proc; end;
The user procedure that receives and processes the data, and supplied web output, will look something like the following:
begin --// if the user supplied a firstname, we call the procedure to process the data if :P1_FIRSTNAME is not null then MyTestProc( firstName => :P1_FIRSTNAME ); end if; end;
create or replace procedure MyTestProc( firstName varchar2 ) is cnt integer; begin htp.prn( 'You have entered the search criteria: '||firstName||'<br> '); select count(*) into cnt from emp where first_name like firstName; htp.prn( 'Number of matching employees: '||to_char(cnt)||' row(s)<br> '); end;