public void ServiceOperationCreate(string operationID, int serviceOperationTypeID, out long serviceOperationID, out bool isCompleted, out string result) { var parameters = new OracleDynamicParameters(); parameters.Add("p_OperationID", OracleDbType.Varchar2, operationID); parameters.Add("p_OperationTypeID", OracleDbType.Int32, serviceOperationTypeID); parameters.Add("p_ServiceOperationID_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output); parameters.Add("p_IsCompleted_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output); parameters.Add("p_Result_out", OracleDbType.Varchar2, null, System.Data.ParameterDirection.Output, 2000); DbConnection.SPExecute("pkg_velin.p_Service_Operation_Create", parameters); serviceOperationID = parameters.GetLongNumber("p_ServiceOperationID_out"); isCompleted = parameters.GetBoolean("p_IsCompleted_out"); result = parameters.GetString("p_Result_out"); }