I tried what you suggested but I was still getting errors:
here is my code:
I'm trying pass the value of the variable "$FILE_NM" returned in the subroutine "get_file" to
the subroutine "Update_T_Received"? I'm needing this value to for my update statement. Thanks!!!
sub get_file
{
connect_dev_app();
$out_File_Ref_Cursor;
$sql = qq(
BEGIN
package.procedure(TO_DATE

p1,:fmt),TO_DATE

p2,:fmt ),

ut_File_Ref_Cursor);
END;
);
$func = $dbh -> prepare($sql);
$func->bind_param("

1",$starttimeStamp);
$func->bind_param("

2",$endtimeStamp);
$func ->bind_param(":fmt","mm/dd/yyyy hh24:mi:ss");
$func ->bind_param_inout("

ut_File_Ref_Cursor", \$out_File_Ref_Cursor, 0,{ora_type=>ORA_RSET});
$func->execute;
# Loop through Cursor Returned from package.procedure
while (($FILE_NM,$RECV_FILE_TS,$LAST_ATTEMPT_TS,$INB_OUT,$LOGICAL_NM) = $out_File_Ref_Cursor->fetchrow_array)
{
(LOGFILE, "SP returned FILE_NM: " . $FILE_NM . "\n");
}
$func->finish;
}
sub Update_T_Received
{
$updatestmt ="UPDATE T_Received SET CMPLT_TS =SYSDATE WHERE FILE_NM = '$FILE_NM'";
$dbh->do($updatestmt) || warn "prepare: $updatestmt: $DBI::errstr";
$dbh->disconnect();
}