How to call procedure of UDT OracleObject
Posted: Wed 17 Feb 2021 06:43
Hello!
I have UDT OracleObject with the following procedure
How to use ExecuteMethod in C#. Could you give me an example, please.
Now I have the following progress:
I have UDT OracleObject with the following procedure
Code: Select all
member procedure set_item(pitem t_variant_named) is
xindex integer;
begin
check_items;
xindex := index_of(pitem.name);
if xindex = -1 then
items.extend;
items(items.last) := pitem;
else
items(xindex) := pitem;
end if;
end;
Now I have the following progress:
Code: Select all
public void SetItem(TVariantNamed tVariantNamed)
{
OracleParameterCollection xparams = new OracleParameterCollection()
{
new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input)
};
var res = OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);
this.OracleObject = xparams["self"].Value as OracleObject;
}