CREATE PROCEDURE MyProcedure(
IN v_M_FILE_ID VARCHAR(20),
INOUT v_M_TRL_REC_CNT_VAR_N INT,
INOUT v_M_FILE_RUL_01_C VARCHAR(10),
INOUT v_M_FILE_RUL_02_C VARCHAR(10),
INOUT v_M_FILE_RUL_03_C VARCHAR(10),
INOUT v_M_FILE_RUL_04_C VARCHAR(10),
INOUT v_M_D_VLID_APPL_NM VARCHAR(20),
INOUT v_M_D_VLID_TY_C VARCHAR(10))
####
my ($M_TRL_REC_CNT_VAR_N, $M_FILE_RULE_01_C, \
$M_FILE_RULE_02_C, $M_FILE_RULE_03_C, \
$M_FILE_RULE_04_C, $M_D_VLID_APPL_NM, \
$M_D_VLID_TY_C);
$sql = "CALL MyProcedure(\'$file_id\',
$M_TRL_REC_CNT_VAR_N,
\'$M_FILE_RULE_01_C\',
\'$M_FILE_RULE_01_C\',
\'$M_FILE_RULE_01_C\',
\'$M_FILE_RULE_01_C\',
\'$M_D_VLID_APPL_NM\',
\'$M_D_VLID_TY_C\')" ;
$sth = $dbh->prepare( $sql_ref )
or die "Can't prepare statement $sql_ref: DBI::errstr";
$rc = $sth->execute
or die "Can't execute statement: $DBI::errstr";
if ( $DBI::err ) {
die "Can't execute statement: $DBI::errstr" ;
}
####
DBD::DB2::st execute failed:
[IBM][CLI Driver][DB2/SUN] SQL0104N An unexpected token "," was found following "LE_CTRL('fsaifdvd ',". Expected tokens may include: "". SQLSTATE=42601