ORA-01008: not all variables bound

Last post 06-30-2005 8:05 AM by swastikagaur. 1 replies.

Sort Posts:

  • Smile [:)] ORA-01008: not all variables bound

    06-28-2005, 4:21 AM
    • Member
      330 point Member
    • chicobaby
    • Member since 10-02-2003, 2:24 AM
    • Posts 66

    here's the excerpt of my code:

    conn.Open()

    Dim reqSQL As String = "INSERT INTO jobRequest(reqNo,userID,reqType,projTitle,dept,d_section,unit,author,targetDate, " _

    & "reqStat,location,approvalNo,evalRem,itscRem,evaltoitscRem,dateSubmit) " _

    & "VALUES(:reqNo,:userID,:reqType,:projTitle,:dept,:d_section,:unit,:author,:targetDate, " _

    & ":reqStat,:location,:approvalNo,:evalRem,:itscRem,:evaltoitscRem,:dateSubmit)"

    Dim reqCmd As New OracleCommand(reqSQL, conn)

    'reqCmd.Parameters.Add("userID", context.User.Identity.Name)

    reqCmd.Parameters.Add("reqNo", OracleType.Number, 5, 1)

    reqCmd.Parameters.Add("userID", OracleType.VarChar, 50, "chico")

    reqCmd.Parameters.Add("reqType", OracleType.Number, 1, 1)

    reqCmd.Parameters.Add("projTitle", OracleType.VarChar, 100, "comsat")

    reqCmd.Parameters.Add("dept", OracleType.VarChar, 50, "mis")

    reqCmd.Parameters.Add("d_section", OracleType.VarChar, 50, "web development")

    reqCmd.Parameters.Add("unit", OracleType.VarChar, 50, "development")

    reqCmd.Parameters.Add("author", OracleType.VarChar, 50, "onats")

    reqCmd.Parameters.Add("targetDate", OracleType.DateTime, 11, "15-Sep-1975")

    reqCmd.Parameters.Add("reqStat", OracleType.Number, 1, 3)

    reqCmd.Parameters.Add("location", OracleType.Number, 1, 1)

    reqCmd.Parameters.Add("approvalNo", OracleType.VarChar, 50, "ok")

    reqCmd.Parameters.Add("evalRem", OracleType.VarChar, 1000, "ok")

    reqCmd.Parameters.Add("itscRem", OracleType.VarChar, 1000, "ok")

    reqCmd.Parameters.Add("evaltoitscRem", OracleType.VarChar, 1000, "ok")

    reqCmd.Parameters.Add("dateSubmit", OracleType.DateTime, 11, "15-Sep-1975")

    reqCmd.ExecuteNonQuery()

    conn.Close()

    what's wrong? please help me. im new to .net with oracle implementation.

    thanks.

  • Re: ORA-01008: not all variables bound

    06-30-2005, 8:05 AM
    • Participant
      1,191 point Participant
    • swastikagaur
    • Member since 03-11-2005, 7:48 PM
    • ..-o0o-..
    • Posts 240

    hy..

    this usually happens when u pass incomplete parameters. That is.. "All substitution variables must have a substituted value before the SQL statement is executed"

    Yes [Y]

     

Page 1 of 1 (2 items)