Execute Oracle SP with Object in- and output parameter

Execute Oracle SP with Object in- and output parameter

  
Does anyone have experience with calling an Oracle stored procedure, that has a input-object parameter and a output-object.

a sample on how Oracle Desiger shows this procedure is:

declare
  -- Non-scalar parameters require additional processing
  service_header_in to_service_header_in;
  response to_special_response;
  service_header_out to_service_header_out;
begin
  -- Call the procedure
  xyz$a_dml.xyz$proc(service_header_in => service_header_in,
                       response => response,
                       service_header_out => service_header_out);
end;


Hi,

I use Oracle Connector to execute Procedures/Functions
Thnx Nuno,

Do you have a sample eSpace for it?

Kind regards,
Matthias
I'am trying to use the ExecuteSP, from the Oracle Connector, to execute a SP. The ExecuteSP has a object as a in and out parameter. I know how to cast a variable(type record) to a object, but how do i cast a object to a record?

see attached sample


 
 
Hi,

At the moment it's hard to make a sample, so i will try to explain.

You need to have a Record as an input and a RecordList as an output.
In the ExecuteSP action you make ToObject(R_IN) and the same to the record list.
After the execution you will have the RecordList filled with the data.


Thanks!

Nuno Rolo wrote:
Hi,

At the moment it's hard to make a sample, so i will try to explain.

You need to have a Record as an input and a RecordList as an output.
In the ExecuteSP action you make ToObject(R_IN) and the same to the record list.
After the execution you will have the RecordList filled with the data.

 
 
 
Just anonther question, is it possible to use nested structures in the SimpleOutput?

My output structure looks this way:





No!

The SimpleOutput is used to receive parameters with one value only. If you want to return a list of values, you should use in the procedure a sys_refcursor, and an independent record list for receive that list. Using the OutpuList


Hi Nuno,

I am having some problems identifying the input parameters.
My procedure is "PROCEDURE SPACTIONLIST (ModulsList IN varchar, p_cursor OUT SYS_REFCURSOR)".
If i understant it correctly, i nead to create a Structure, for instance called 'InputParameter' with many columns as parameters. For this case, i will have one column in the 'InputParameter' structure called 'ModulsList' with the type Text, right?

Thanks,
João


Hi,
Yes thats right, and in the action you will have a record of that structure.