Hi All,
my $stmt = "begin call_procedure(:1,:2,:3,:4); end;";
my $csr = $dbh -> prepare ($stmt);
$dbh -> PrintError ($DBI::errstr, 'fatal') if (! $csr);

$csr->bind_param_inout (':1', \$column1,$int_len);
$csr->bind_param (':2', $column2, {ora_type=>96});
$csr->bind_param (':3', $column3, {ora_type=>96});
$csr->bind_param_inout (':4', \$column4, $int_len);

if (! $csr->execute) {
$dbh -> PrintError ($DBI::errstr, 'fatal', $stmt);
}


This one sometimes returns a datatype conversion error. Please advice,

Error: ORA-28528: Heterogeneous Services datatype conversion error ORA-02063: preceding line from DSN7_DLNK ORA-06512: at "XXXX", line 464 ORA-06512: at "XXXXX", line 272 ORA-06512: at "XXXX", line 49 ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute)begin call_procedure (:transnum,:transcode,:luname,:apirc); end;