Re: cx_Oracle issues

2009-01-05 Thread huw_at1
On Dec 18 2008, 10:34 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 16, 12:17 pm, huw_at1 huwdjo...@gmail.com wrote: On Dec 15, 12:59 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 15, 2:44 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 11, 5:34 pm, ron.re...@gmail.com

Re: cx_Oracle issues

2008-12-18 Thread huw_at1
On Dec 16, 12:17 pm, huw_at1 huwdjo...@gmail.com wrote: On Dec 15, 12:59 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 15, 2:44 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 11, 5:34 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 10, 9:48 am, huw_at1

Re: cx_Oracle issues

2008-12-16 Thread huw_at1
On Dec 15, 12:59 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 15, 2:44 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 11, 5:34 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 10, 9:48 am, huw_at1 huwdjo...@gmail.com wrote: Hey all. When usingcx_Oracleto run a

Re: cx_Oracle issues

2008-12-16 Thread huw_at1
On Dec 15, 12:59 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 15, 2:44 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 11, 5:34 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 10, 9:48 am, huw_at1 huwdjo...@gmail.com wrote: Hey all. When usingcx_Oracleto run a

Re: cx_Oracle issues

2008-12-15 Thread ron.re...@gmail.com
On Dec 15, 2:44 am, huw_at1 huwdjo...@gmail.com wrote: On Dec 11, 5:34 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 10, 9:48 am, huw_at1 huwdjo...@gmail.com wrote: Hey all. When usingcx_Oracleto run a procedure like: cursor.execute(select (obj.function(value)) from

Re: cx_Oracle issues

2008-12-15 Thread huw_at1
On Dec 11, 5:34 pm, ron.re...@gmail.com ron.re...@gmail.com wrote: On Dec 10, 9:48 am, huw_at1 huwdjo...@gmail.com wrote: Hey all. When using cx_Oracle to run a procedure like: cursor.execute(select (obj.function(value)) from table where id=blah) I am getting the following error:

Re: cx_Oracle issues

2008-12-15 Thread Hrvoje Niksic
huw_at1 huwdjo...@gmail.com writes: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 This error is a problem with the PL/SQL, not cx_Oracle.  You need to debug obj.function to see what kind of data is being accessed and then a data analysis

Re: cx_Oracle issues

2008-12-11 Thread ron.re...@gmail.com
On Dec 10, 9:48 am, huw_at1 [EMAIL PROTECTED] wrote: Hey all. When using cx_Oracle to run a procedure like: cursor.execute(select (obj.function(value)) from table where id=blah) I am getting the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

cx_Oracle issues

2008-12-10 Thread huw_at1
Hey all. When using cx_Oracle to run a procedure like: cursor.execute(select (obj.function(value)) from table where id=blah) I am getting the following error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 Looking at cursor.description I get:

Re: cx_Oracle issues

2008-12-10 Thread James Mills
On Thu, Dec 11, 2008 at 2:48 AM, huw_at1 [EMAIL PROTECTED] wrote: Any tips - i have never seen this error before but am guessing that the value being returned is too big for the buffer size set for the cursor. the procedure fetches data from a LOB. Any suggestions/confirmations? Could you