On Wed, Apr 03, 2002 at 12:54:50PM +0200, T. van Dyk wrote: > I'm having a problem with selecting rows from a query which joins 6 tables. > I'm sure its a buffer-related problem but I cannot figure out how to > overcome this. The query returns about 60 rows with no problems, then fails > with the Oracle truncation error ORA-24345. > > Here's the trace output from DBI->trace( 2 ): > > --------------- > > <- fetchrow_array= ( 'NORDM/RO' 'T319741' ) [2 items] row376 at > advx_stats_test.pl line 357 > -> fetchrow_array for DBD::Oracle::st > (DBI::st=HASH(0x401c38d0)~0x401c1504) > !! ERROR: 24345 'ORA-24345: A Truncation or null fetch error occurred > (DBD ERROR: ORA-01406 error on field 1 of 2, ' > <- fetchrow_array= ( ) [0 items] row377 at advx_stats_test.pl line 357 > -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x401c1504)~INNER) > <- DESTROY= undef at advx_stats_test.pl line 279 > -> disconnect for DBD::Oracle::db (DBI::db=HASH(0x401e4ecc)~0x401c3960) > <- disconnect= 1 at advx_stats_test.pl line 586 > > ------------- > > Column 1 is VARCHAR2(32) and column 2 is VARCHAR2(8).
Please include the 'describe' part of the trace, in fact everything from the prepare thru the execute. That'll show the query and what buffers DBD::Oracle has setup. Tim.