11g plsql web service

Making a plsql web service in 11g is very easy but you have to think about your function, procedure and parameters names else it can result in a strange wsdl method and parameter names.
Here is a example of a function.

create or replace package scott_ws is
  function get_current_time ( date_format varchar2)
  return varchar2
  ;
end scott_ws;

create or replace package body scott_ws is
  function get_current_time ( date_format varchar2)
  return varchar2
  is
    v_time varchar2(20);
  begin
    if date_format is null
    then
      return 'empty format';
    end if;
    select to_char(sysdate,date_format) into v_time from dual;
    return v_time;
  exception
  when others
  then
    return 'error';
  end;
end scott_ws;

The package name is not used in the wsdl creation. If you want to have a capital character then you have to use a underscore _ . Jdelevoper automatically remove the underscore and capitalize the following character. In Oracle plsql is common to use p_format as a parameter of a function but this results in pFormat.
So we are ready to create a plsql web service.

Here we make a database connection and we select the oracle package.

Select our function. And we are ready with our webservice. Here is how the wsdl looks like

Let's make it a bit more interesting by using security and logging.

Let's start the webservice and look at the result. As username I use a standard account oc4jadmin. You can also use an another account but you have to edit the jazn of the embedded oc4j.