nHibernate Doesn't update other table through Oracle Package in same session
===

In a window application we are using nHibernate. We are facing problem when updating data a table (Tag1 or Tag2) and in the same ISession we are inserting data from the table  into another table (QA Table) using Oracle Package. On commit Oracle package doesnt't see the changed data in the Tag1/Tag2 table hence the modified data is not updated in QA table, might be becuase being called in the same session?
 
        using (ISession session = iNhibernet.OpenSession())
                {

                    using (ITransaction transaction = session.BeginTransaction())
                    {

                        try
                        {
                            // Business Entity Saved in Tag1/Tag2 Table
                            session.SaveOrUpdate(l);
                        }
                        catch (Exception ex)
                        {
                            ErrorLogExceptionHandler.ErrorLog(ref ex);
                            throw new Exception("Unable to save data");
                        }
                        // Calling Oracle Package to Compare Tag1 and Tag2 data and inserting data in QA Table.
                        IDbCommand db = ProductionLog.ProductionLogUpdate(l.ProductionlogSeqNo, loadAction) as DbCommand;
                        db.Connection = session.Connection;
                        try
                        {
                            db.ExecuteNonQuery();
                        }
                        catch (Exception ex)
                        {
                            ErrorLogExceptionHandler.ErrorLog(ref ex);
                            throw new Exception("Unable to insert in production log");
                        }
                    transaction.Commit();
		   }
		}
Can some help.

Thanks,




