Creating a SOAP service that accepts a variable number of arguments
727483Oct 12 2009 — edited Dec 4 2009Hi,
I am using Oracle 11g Enterprise Edition 11.0.6.0, and I am trying to use the web services feature of the XML DB to create SOAP services. I would like to create a SOAP service that accepts a variable number of input arguments. I have tried to do this by creating a stored procedure that takes a varray as in parameter. The stored procedure compiles, but the WSDL that is generated for this procedure is empty (see below for the code snippets).
Does Oracle 11g support stored procedures with varray parameters? Is there another way to create SOAP services in Oracle that accept a variable number of arguments? I am trying to accept a variable number of records, so using a comma-separated list is not an option.
Any suggestions?
Regards,
Peter
create or replace type t_number_array as varray(25) of number(3);
procedure var_args_in(vargs in t_number_array) is
begin
null;
end;