Hi

  I am having a trouble with SA-oracle-Blob datatype.
  Here I have a test program like this.

      import pkg_resources
      pkg_resources.require("cx-Oracle>=5.0.3")
      import cx_Oracle
      import sqlalchemy
      from sqlalchemy.sql import select

     db=sqlalchemy.create_engine('oracle://cse:c...@localhost')
     conn = db.connect()

      result=conn.execute(select(["dummy"]))
      print "helloooooooooooooo"
      print result.fetchone()

      conn.close()

     cse is the username and password for ORACLE schema

    duumy is the table name ,it has a column with datatype BLob.

    For this am geting the result with the error,

    ORA-00932: inconsistent datatypes: expected NUMBER got BLOB

    Is there is any solution so that i do can do more complecated
    select statements.

   Is Blob not supported for ORACLE-SA

   Any help is encouraged.

                                THANKS

-- 
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.

Reply via email to