Re: cx_Oracle issues

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

Re: cx_Oracle issues

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

Re: cx_Oracle issues

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

Re: cx_Oracle issues

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

Re: cx_Oracle issues

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

Re: cx_Oracle issues

2008-12-15 Thread Hrvoje Niksic
huw_at1 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 of th

Re: cx_Oracle issues

2008-12-15 Thread huw_at1
On Dec 11, 5:34 pm, "ron.re...@gmail.com" wrote: > On Dec 10, 9:48 am, huw_at1 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:

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

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

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: