Thanks - at least In now know I was in a dead end

Sorted it though

my $sql = "call PROC_MEMB(?,?,?,?,?,?,?,?,?,?,?,?,?,?,\@code,\@key ,\@map)";
$RegUser = $DBRegUser->prepare($sql);
$RegUser->bind_param(1,$action);
$RegUser->bind_param(2,$user_uid);
$RegUser->bind_param(3,$locale);
$RegUser->bind_param(4,$username);
$RegUser->bind_param(5,$pass);
$RegUser->bind_param(6,$dob);
$RegUser->bind_param(7,$gender);
$RegUser->bind_param(8,$title);
$RegUser->bind_param(9,$letters);
$RegUser->bind_param(10,$firstname);
$RegUser->bind_param(11,$initials);
$RegUser->bind_param(12,$lastname);
$RegUser->bind_param(13,$knownas);
$RegUser->bind_param(14,$suser);
$RegUser->execute();
$RegUser = $DBRegUser->prepare("select \@code, \@key, \@map");
$RegUser->execute();
my @res=$RegUser->fetchrow_array();
print "Code::$res[0], Key::$res[1], Map::$res[2]\r";

Only issue I have with this whole thing was it was wrapped in a while loop was outside so it went really fast. Having to bring it all into the loop as I can only get access the the sp output if I stay on the same handle.

Not very efficent - maybe when mysql get more mature with their sp's will be able to revisit this - or if the DBI and MySQL DBD actually sort out method of processing @ stuff in sp's

Thanks again