OracleObject variable and ClientDataSet parameters

[Roeland]

Hi,

How do i set TOracleObject Variables in the Param list of my ClientDataSet?

Example:
In my OracleDataSet.SQL:

begin
array_exmple.view_col(p_cursor => :cursor,
p_array => _array);
end;

I defined p_Array as an Object.

Then i linked a DataSetProvider and a ClientDataSet to the OracleDataSet.

Now, when i do "Fetch Params" my p_Array variable becomes a p_Array INTEGER parameter?

How can i solve this problem?

 

[Marco Kalter]

This is not supported. Only scalar parameters are supported. You will need to create a specific procedure to get this array from the server to the client.