Oracle Type as Table
Posted: Tue 23 Jun 2020 17:55
I'm trying to work with OracleTypes in c#. here are the types:
create type ocl.ingredient sa object( ingredient_id int, weight int)
create type ocl.recipe as table of ingredient;
And I have a stored procedure:
create procedure test_proc (v_table as recipe)
as
begin
...
end;
/
My Question is, how can you I pass an the ocl.recipe type (which is a table of ingredient)
to this procedure? I looked at the documentation, and I am able to create the object (see below)
but how do I create an array of these and pass it to the procedure:
OracleObject ingredient = new OracleObject("ocl.ingredient", con);
ingredient[ingredient_id] = 1;
etc..
create type ocl.ingredient sa object( ingredient_id int, weight int)
create type ocl.recipe as table of ingredient;
And I have a stored procedure:
create procedure test_proc (v_table as recipe)
as
begin
...
end;
/
My Question is, how can you I pass an the ocl.recipe type (which is a table of ingredient)
to this procedure? I looked at the documentation, and I am able to create the object (see below)
but how do I create an array of these and pass it to the procedure:
OracleObject ingredient = new OracleObject("ocl.ingredient", con);
ingredient[ingredient_id] = 1;
etc..