Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2001
    Posts
    3

    Question Unanswered: SQL Data Type Out of Range

    Hi

    "[Microsoft] [ODBC Driver Manager] SQL Data Type Out of Range" this error has been occued while excuting oracle stored procedure. i have vb 6 , oracle 8.0.5 and MDAC 2.7 lates ODBC drivers installed on the server. it was running perfectly without sql server. For different purpose i have installed MS SQL server on the same machine. then the said error getting raised within an vb , oracle application.

    Could you tell me what would be different reasons and solutions for the same.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What kind of data types involved while executing this SP?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Aug 2001
    Posts
    3

    Thumbs up

    Hi Satya

    Thanks for reply

    following is my stored procedure execution statements

    Set cmndGRNCMD = New ADODB.Command
    cmndGRNCMD.ActiveConnection = conCN
    cmndGRNCMD.CommandType = adCmdStoredProc
    cmndGRNCMD.CommandText = "SAVEGRNDETAILS"

    With cmndGRNCMD
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_WORKCENTERID", adVarChar, adParamInput, 10, strWorkcenterId)
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_TRANSACTIONID", adVarChar, adParamInput, 2, strTransactionId)
    cmndGRNCMD.Parameters.Append .CreateParameter("INT_GRNNO", adNumeric, adParamInput, 7, lngGRNNO)
    cmndGRNCMD.Parameters.Append .CreateParameter("DT_GRNDATE", adDate, adParamInput, 10, dtpGRNDate)
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_TRANSACTIONTYPE", adVarChar, adParamInput, 1, strTransactionType)
    cmndGRNCMD.Parameters.Append .CreateParameter("DT_TRANSACTIONDATE", adDate, adParamInput, 10, dtpGRNDate)
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_TRANSACTIONMONTH", adVarChar, adParamInput, 3, strTransactionMonth)
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_TRANSACTIONYEAR", adVarChar, adParamInput, 4, strTransactionYear)
    End With

    'parameter added for a/c integration
    Dim intAccountIntegration As Integer

    If blnIntegratedAccounts = True Then
    intAccountIntegration = 1
    Else
    intAccountIntegration = 0
    End If

    With cmndGRNCMD
    cmndGRNCMD.Parameters.Append .CreateParameter("INT_ACCINTEGRATED", adNumeric, adParamInput, 2, intAccountIntegration)
    cmndGRNCMD.Parameters.Append .CreateParameter("STR_VOUCHERNO", adBSTR, adParamInput, 15, strVoucherNumber)
    cmndGRNCMD.Parameters.Append .CreateParameter("INT_STOCK_1OR_2", adNumeric, adParamInput, 2, INT_STOCK_1OR_2)
    End With

    cmndGRNCMD.Execute

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •