Ah! I will keep track of it - for now, I will just ignore AttributeError
exception.
I am loving sqlalchemy, thanks for creating and maintaining it!
-GP
On Monday, March 16, 2015 at 11:37:36 PM UTC-4, Michael Bayer wrote:
GP pandit...@gmail.com javascript: wrote:
That's what I thought,
GP pandit.gau...@gmail.com wrote:
OK, is “cancellation_obj” a column object with CLOB as the datatype ?
Yes, that's how it's defined in the database.
Because of dynamic nature of the code, I was using append_column without
specifying column type. I made changes to define column in
GP pandit.gau...@gmail.com wrote:
That's what I thought, and it works, but there seems to be a difference in
how resultset is handled when you select LOB column.
Here is a basic script, that selects record from a source table which has 36
rows. It fetches 10 records at a time.
from
That's what I thought, and it works, but there seems to be a difference in
how resultset is handled when you select LOB column.
Here is a basic script, that selects record from a source table which has
*36* rows. It fetches *10* records at a time.
from sqlalchemy import Table, select,
I think now I (probably) know where this may be coming from.
You asked
is the original query a plain string and not a Core SQL expression
The way I am forming the query is by using select , append_column,
append_whereclause and finally *append_from*('my_table'). I think this
pretty much
So that's what was happening:
This select construct *fails*:
select_query = select()
select_query.append_column(contract_id)
select_query.append_column(cancel_dt)
select_query.append_column(cancellation_obj)
select_query.append_from(source_table_name)
But this select construct *works*:
Hello,
While trying to insert into an Oracle table with one column defined as
CLOB, I get the following error:
File
/home/x/.local/lib/python3.4/site-packages/sqlalchemy/engine/default.py
, line 442, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.NotSupportedError:
GP pandit.gau...@gmail.com wrote:
Hello,
While trying to insert into an Oracle table with one column defined as CLOB,
I get the following error:
File
/home/x/.local/lib/python3.4/site-packages/sqlalchemy/engine/default.py,
line 442, in do_execute
cursor.execute(statement,