in reply to problem calling MySQL stored proc

Please show us the source code for db_name.myProc. Does it have any input or output arguments? What does it return? What does your sample data look like?
--
print map{chr}unpack(q{A3}x24,q{074117115116032097110111116104101114032080101114108032104097099107101114})

Replies are listed 'Best First'.
Re^2: problem calling MySQL stored proc
by ethrbunny (Monk) on Jun 14, 2007 at 16:23 UTC
    Both machines are hitting the same DB on the same server. Its MySql 5.0.12.

    The proc in question is only returning one result set which is another reason why this issue baffles me.

    The proc does a series of joins into a temporary table. It then does a 'select distinct' which creates the result set that Im looking for.
[reply]

In Section Seekers of Perl Wisdom