DBD::Oracle::st fetchrow_hashref warning when fetching multiple records from the table.

Hello, I am getting a warning like "DBD::Oracle::st fetchrow_hashref warning: (err=0, errstr=undef, state=undef) [for Statement " SELECT item.nreference, item.chold, item.npieces, item.nweight, item.ncube, item.cshippername, item.cwarehouselocation,

Re: missing records while running a query using DBI

Hi I have changed the fetching loop as you said and now I am getting 25 result and my script works fine now. Thankyou. But at end of execution,I am getting a warning like " DBD::Oracle::st fetchrow_hashref warning: (err=0, errstr=undef, state=undef) [for Statement " SELECT item.nrefer

Re: missing records while running a query using DBI

Hi Lan, Thank you for your reply. I have tried the query by changed placeholder $query = qq{ SELECT item.* FROM tmp_loadplans loadplan, tmp_loadplan_items item WHERE loadplan.nreference_code = ? AND loadplan.id = item.tmp_loadplans_id };