Hints and tricks for Oracle and other stuff...

You can call PL/SQL procedures or packages with ! in front of the name. When you use !, it means you have dynamic parameters, then procedure must have this structure:

procedure procedure_name (
   name_array in owa.vc_arr,
   value_array in owa.vc_arr
) is
begin
  …
end;

Parameters and theirs values are saved in name_array and value_array parameters.

If you are using procedures with dynamic parameters and you wont write ! in URL location then you must write RewriteRule. You must put it in any .conf file of Apache. The best place is in the beginning of dads.conf. The rule can be like that:

RewriteEngine on
RewriteRule ^/xyz_test/docs(.*) /xyz_test/docs$1 [PT,L]
RewriteRule ^/xyz_test/(.*) /xyz_test/!$1 [PT,L]

If you don't use !, then your procedure parameters must exists on HTML page like input objects.