Hi This is my class definition
class TaskCalendar(DeclarativeBase): __tablename__ = 'task_calendars1' cal_id = Column(Integer,Sequence('id_seq'), primary_key=True) task_id = Column(Integer, ForeignKey('tasks.task_id')) dow = Column(Integer) month = Column(Integer) day = Column(Integer) hour = Column(Integer) minute = Column(Integer) task = relation(Task, backref=backref('calendar')) This is what am trying to do tasks=DBSession.query(TaskCalendar).options(eagerload('task')) The query is as follows SELECT task_calendars1.cal_id AS task_calendars1_cal_id, task_calendars1.task_id AS task_calendars1_task_id,tasks_1.name AS tasks_1_name, tasks_1.entity_id AS tasks_1_entity_id, tasks_1.entity_name AS tasks_1_entity_name, tasks_1.context AS tasks_1_context FROM task_calendars1 LEFT OUTER JOIN tasks tasks_1 ON tasks_1.task_id = task_calendars1.task_id if i remove tasks_1.context this query works fine context column is of pickletype datatype in class and Blob in Database This is the error message: ORA-00932: inconsistent datatypes: expected NUMBER got BLOB Thankful for any suggestions -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.