Today, we finally solved the problem of passing and Saving big data types through stored procedures. I have found a lot of information on the Internet, but I cannot try it the most. finally, I wrote a function to execute the stored procedure according to Microsoft's msdn example.
///
/// Execute the stored procedure with clob, blob, and nclob large object parameter types
///
///Stored Procedure name
///Stored Procedure Parameters
///Location of large objects in Parameters
///Value of a large object
///Specific types of large objects
Public void runprocedure (string storedprocname, idataparameter [] parameters, int [] index, byte [] [] tempbuff, oracletype [] dbtype)
{
Connection. open ();
Oracletransaction Tx = connection. begintransaction ();
Oraclecommand cmd = connection. createcommand ();
Cmd. Transaction = TX;
String type = "declare ";
For (INT I = 0; I