I have a procedure that returns CLOB data.
Code: Select all
PROCEDURE GET_LNK_SYNC_SERV_ENT_DATA(P_LINK_SYNC_SERV_ENT_ID IN LINK_SYNC_SERVICES_ENTITIES.ID%TYPE,
P_IS_FULL_SYNC IN INTEGER,
P_XML_DATA OUT CLOB);
Code: Select all
using (OracleConnection oraConnection = new OracleConnection(GetConnectionString()))
{
oraConnection.Open();
OracleCommand oraCommand = new OracleCommand("EL_DIC_SYNC.GET_LNK_SYNC_SERV_ENT_DATA", oraConnection);
oraCommand.CommandType = CommandType.StoredProcedure;
oraCommand.Parameters.Clear();
oraCommand.Parameters.Add("P_LINK_SYNC_SERV_ENT_ID", OracleDbType.Number, 85731, ParameterDirection.Input);
oraCommand.Parameters.Add("P_IS_FULL_SYNC", OracleDbType.Number, 1, ParameterDirection.Input);
oraCommand.Parameters.Add("P_XML_DATA", OracleDbType.Clob, ParameterDirection.Output);
using (OracleDataReader oraDataReader = oraCommand.ExecuteReader(CommandBehavior.SequentialAccess))
{
// ...
}
}
Code: Select all
oraCommand.ExecuteReader