[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-05 Thread Boris Aramis Aguilar Rodríguez
Hi :) I've just managed to fix my issue by adding/modifying a couple of methods of the *pydal.adapters.oracle.OracleAdapter class*; everything seems to be working for me def _insert(self, table, fields): table_rname = table.sqlsafe if fields: keys =

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-05 Thread Massimo Di Pierro
This great. It is a good solution for now and can be used as example of similar solutions for other adapters. On Wednesday, 5 August 2015 12:17:49 UTC-5, Boris Aramis Aguilar Rodríguez wrote: Hi :) I've just managed to fix my issue by adding/modifying a couple of methods of the

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-04 Thread Niphlod
ok, we were discussing the same thing over at pydal's repo to address another issue, that is closely related . https://github.com/web2py/pydal/issues/155 On Monday, August 3, 2015 at 8:57:44 PM UTC+2, Boris Aramis Aguilar Rodríguez wrote: I've found the following: To insert a text using

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-03 Thread Boris Aramis Aguilar Rodríguez
I've found the following: To insert a text using the cx_Oracle driver directly if you do something like import cx_Oracle connection = cx_Oracle.connect('connectionstring') cursor = connection.cursor() p = '' for i in range(1,1): p += str(i) sss = INSERT INTO

[web2py] Re: Oracle CLOB/text insert adapter issues

2015-08-03 Thread Niphlod
to help pinpoint the issue, how do you insert a text, let's say of 8000 chars, into Oracle, using python and the cxOracle driver ? On Monday, August 3, 2015 at 5:51:16 PM UTC+2, Boris Aramis Aguilar Rodríguez wrote: Hi, I've been currently working with Oracle as a database backend, I have