I am not sure if I get your problem correct or not…
but may be this solution will work for you. You may be already knowing this case and your problem is advanced than below.
When calling Oracle stored procedure from webMethods Enterprise Server, you have to define a cursor type in package specification like following:
(pls note I am using ! instead of angled brackets to signify name to be replaced)
CREATE OR REPLACE PACKAGE !pkgName! IS
Type !recordTypeName! is record
– and so on…
TYPE !RefCursorType! IS REF CURSOR RETURN !recordTypeName!;
procedure !myProc!( out_cursor in out !RefCurType!
, inField1 in !fielddatatype!
, inField2 in !fielddatatype!
– and so on
And in the stored procedure you have to send output data as
open out_cursor for
select !outfield1!, !outfield2!, !outfield3! – and so on
There can be only one out put field and that is the ref cursor passed in the very first parameter.