I use the following components:
1) dotConnect for Oracle Professional 9.14.1180
2) MS VS 2019
3) Oracle Client 12c 12.2.0.1.0 x86
Then I call the oracle method to pass blob.
Code: Select all
public void SetItem(TVariantNamed tVariantNamed)
{
OracleParameterCollection xparams = new OracleParameterCollection()
{
new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input),
};
OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);
if (xparams.Contains("self") && xparams["self"].Value as OracleObject != null)
this.OracleObject = xparams["self"].Value as OracleObject;
}
Note that the following code was successfully executed for dotConnect for Oracle Professional 6.60.258 and Oracle Client 12c 12.2.0.1.0 x86:
Code: Select all
public void SetItem(TVariantNamed tVariantNamed)
{
OracleParameterCollection xparams = new OracleParameterCollection()
{
new OracleParameter("pItem", OracleDbType.Object, tVariantNamed.OracleObject, ParameterDirection.Input),
};
OracleObject.ExecuteMethod(_connection, "SET_ITEM", xparams);
}
What happend? How to solve this problem?
Thanks!