CREATE OR REPLACE PROCEDURE TP_EVENT_ADD(in_ProcessSourceId NUMBER, in_ProcessId NUMBER
    out_rowid OUT ROWID) 
IS
BEGIN

INSERT INTO TP_EVENT E
   (PROCESSSOURCEID, PROCESSID)
 VALUES
   (in_ProcessSourceId, in_ProcessId)
 RETURNING E.ROWID INTO out_rowid;
 
END TP_EVENT_ADD;
/

public new T Add(T entity)
        {
            var ret = entity;
            using (var cn = this.ConnectionProvider.GetConnection())
            {
                var cmd = cn.CreateCommand();
                cmd.CommandText = string.Concat(this.GetTableName(), "_ADD");
                cmd.CommandType = CommandType.StoredProcedure;
                this.SetAddParameters(cmd, entity);
                var rowid = cmd.Parameters.Add("out_rowid", OracleDbType.Varchar2, ParameterDirection.Output);

                cn.Open();

                var rdr = cmd.ExecuteNonQuery();

                if (rowid.Value == DBNull.Value)
                    return default(T);
                else
                {
                    ret.RowId = (string) rowid.Value;
                }
            }

            return ret;
        }

 delete from TP_EVENT where rownum=1;