error: invalid numer

From: Jerry Preston <g-preston1_at_ti.com>
Date: Wed, 15 Jan 2003 16:31:41 -0600
Message-ID: <b04nh3$7p9$1@tilde.itg.ti.com>

Hi!

I am using perl to access oracle 8.1.7. I get the error: invalid number with the following code.

      my $sql="insert into EE_SPARES_SHOP ( STATUS, SITE, CUSTOMER_CONTACT, CUSTOMER_E_MAIL,

                                                   TTC_REPRESENTITIVE,
SYSTEM_TYPE, SYSTEM_NAME, TEST_HEAD,
                                                   SYSTEM_SERIAL_NUMBER,
PART_NUMBER, PART_TYPE, PART_DESCRIPTION,
                                                   BOARD_SERIAL_NUMBER, QTY,
FAILURE, TUI_REV, CAL_DIAGS_REV,
                                                   DIAG_THAT_FAILED,
RESULTS_FILE, RMA_NUMBER, WEB, FAIL_DATE
                                              )
               values( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, to_date( '$Fail_date', 'MM/DD/YY' ) )";
      my $sth = $t_dbh->prepare( $sql );
      die $t_dbh->errstr if $t_dbh->err;

      print "\n$Schema, $Status, $Site, $Customer_Contact, $Customer_e_mail,


$TTC_Representitive, $System_Type,

               $System_Name, $test_head, $System_Serial_Number,


$Part_Number, $Part_Type, $Part_Description,

               $Board_Serial_Number, $Qty,  $Failure, $TUI_Rev,


$Cal_Diags_Rev, $Diag_that_Failed, $Results_File,

               $RMA_NUMBER*" if $DEBUG;

      $sth->execute( $Status, $Site, $Customer_Contact, $Customer_e_mail,


$TTC_Representitive, $System_Type,

                     $System_Name, $test_head, $System_Serial_Number,


$Part_Number, $Part_Type, $Part_Description,

                     $Board_Serial_Number, $Qty,  $Failure, $TUI_Rev,


$Cal_Diags_Rev, $Diag_that_Failed, $Results_File,

                     $RMA_NUMBER, $YES,
                   ) || die "Cannot execute save_rma_request_data insert

Statement!!<br>$DBI::errstr";

I am not sure why. I have 21 blind inputs and one not. I get my error on the execute. If I add FAIL_DATE, I get that I do not have 22 blind vars.

Any ideas?

Thanks,

Jerry Received on Wed Jan 15 2003 - 16:31:41 CST