0 Replies Latest reply on Sep 30, 2002 8:19 PM by 271367

    Invalid Number on Select Into Statement

    271367
      I have a select into statement that is pulling variables from my application and inserting them into a database. The variables are being assigned the proper numbers and the numbers are in the correct format to be put into Oracle but I keep getting the error "Invalid Number". Here is the code:
      OraDatabase.ExecuteSQL ("INSERT INTO IM (IM_KEY,IM_ACT_MAT,IM_AVG_MAT,IM_PRICES1,IM_PRICES2,IM_PRICES3,IM_PRICES4,IM_PRICES5)VALUES (' & IMKEY & ',' & IMACTMAT & ',' & IMAVGMAT & ',' & IMPRICES1 & ',' & IMPRICES2 & ',' & IMPRICES3 & ',' & IMPRICES4 & ',' & IMPRICES5 & ')")

      Can anyone tell me where I'm going wrong? Thanks, Jeremy