I am using DBD::ASAny.  I am calling a stored procedure to insert rows
into a table. Some of the parameters that I want to pass might have null
in them, but I am having trouble using a variable and place holder that
has the value undef.  It keeps core dumping.  Here is the code that I'm
working with. What am I missing?

$first_name = 'sherry';
$last_name = 'graham';
$middle_initial = 'a';
$patient_title = undef;
$sth = $dbh->prepare('call add_person (?, ?,?,?,?)');
$sth->bind_param(1,$first_name);
$sth->bind_param(2,$last_name);
$sth->bind_param(3,$middle_initial);
$sth->bind_param(4,$patient_title);
$sth->bind_param_inout(5,\$person_id,500);
$sth->execute();

Thanks!
Sherry Graham
[EMAIL PROTECTED]
Applied Systems Intelligence, Inc.

Reply via email to