[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQL Error - Data Type Has Changed?
- Subject: Re: SQL Error - Data Type Has Changed?
- From: "C. Duncan Hudson" <c_duncan_hudson@YAHOO.COM>
- Date: Thu, 23 Jul 1998 06:01:01 -0700
> Here's another thought on how you might capture your
> problem.
>
> Before executing your SQR, go to your control panel,
> and open ODBC32...
Paul,
I turned on, as you suggested, ODBC logging on and captured my SQR
error. I have looked through the log, but I really can't make out
what my problem is. Incase you (or anyone else who knows how to read
this stuff) get a free moment to look at my results, I have attached
what you referenced as pertinent sections of the log. Thanks in
advance for any further help you maybe able to provide,
Duncan.
---------------------------------------------
SQL Prepare for offending statement:
wbench32 ba:144 ENTER SQLPrepare
HSTMT 0x0220c200
UCHAR * 0x0018b218 [ -3] "select icost.gldebitacct,
icost.glcreditacct, to_char(trunc(icost.linecost * 100)),
icost.linecost, icost.percentage from maxdemo.invoicecost icost where
invoicenum = ? "
SDWORD -3
---------------------------------------------
Subsequent SQL Binds for offending statement:
wbench32 ba:144 ENTER SQLBindCol
HSTMT 0x0220c200
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c5b8
SDWORD 32
SDWORD * 0x0018c784
wbench32 ba:144 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c200
UWORD 1
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c5b8
SDWORD 32
SDWORD * 0x0018c784 (0)
wbench32 ba:144 ENTER SQLBindCol
HSTMT 0x0220c200
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c5e8
SDWORD 32
SDWORD * 0x0018c788
wbench32 ba:144 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c200
UWORD 2
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c5e8
SDWORD 32
SDWORD * 0x0018c788 (0)
wbench32 ba:144 ENTER SQLBindCol
HSTMT 0x0220c200
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c618
SDWORD 41
SDWORD * 0x0018c78c
wbench32 ba:144 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c200
UWORD 3
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c618
SDWORD 41
SDWORD * 0x0018c78c (0)
wbench32 ba:144 ENTER SQLBindCol
HSTMT 0x0220c200
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c690
SDWORD 79
SDWORD * 0x0018c790
wbench32 ba:144 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c200
UWORD 4
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c690
SDWORD 79
SDWORD * 0x0018c790 (0)
wbench32 ba:144 ENTER SQLBindCol
HSTMT 0x0220c200
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c728
SDWORD 79
SDWORD * 0x0018c794
wbench32 ba:144 EXIT SQLBindCol with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c200
UWORD 5
SWORD 1 <SQL_C_CHAR>
PTR 0x0018c728
SDWORD 79
SDWORD * 0x0018c794 (0)
---------------------------------------------
SQL Error, and several preceding sql log events:
wbench32 ba:144 ENTER SQLRowCount
HSTMT 0x0220c558
SDWORD * 0x0012e7d4
wbench32 ba:144 EXIT SQLRowCount with return code 0
(SQL_SUCCESS)
HSTMT 0x0220c558
SDWORD * 0x0012e7d4 (1)
wbench32 ba:144 ENTER SQLFetch
HSTMT 0x022065a0
wbench32 ba:144 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 0x022065a0
wbench32 ba:144 ENTER SQLBindParameter
HSTMT 0x0220bea8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
UDWORD 4
SWORD 0
PTR 0x001dbe70
SDWORD 4
SDWORD * 0x0016a5a4
wbench32 ba:144 EXIT SQLBindParameter with return code 0
(SQL_SUCCESS)
HSTMT 0x0220bea8
UWORD 1
SWORD 1 <SQL_PARAM_INPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
UDWORD 4
SWORD 0
PTR 0x001dbe70
SDWORD 4
SDWORD * 0x0016a5a4 (4)
wbench32 ba:144 ENTER SQLExecute
HSTMT 0x0220bea8
wbench32 ba:144 EXIT SQLExecute with return code -1 (SQL_ERROR)
HSTMT 0x0220bea8
wbench32 ba:144 ENTER SQLError
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
UCHAR * 0x06010940 (NYI)
SDWORD * 0x0012e578
UCHAR * 0x0012e588
SWORD 513
SWORD * 0x0012e572
wbench32 ba:144 ENTER SQLErrorW
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
WCHAR * 0x0012e524 (NYI)
SDWORD * 0x0012e578
WCHAR * 0x0012e124
SWORD 1024
SWORD * 0x0012e572
wbench32 ba:144 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
WCHAR * 0x0012e524 (NYI)
SDWORD * 0x0012e578 (0)
WCHAR * 0x0012e124 [ 194] "[INTERSOLV][ODBC Oracle
driver]Data type for parameter 1 has changed since first SQLExecute
call."
SWORD 1024
SWORD * 0x0012e572 (194)
wbench32 ba:144 EXIT SQLError with return code 0 (SQL_SUCCESS)
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
UCHAR * 0x06010940 (NYI)
SDWORD * 0x0012e578 (0)
UCHAR * 0x0012e588 [ 97] "[INTERSOLV][ODBC Oracle
driver]Data type for parameter 1 has changed since first SQLExecute
call."
SWORD 513
SWORD * 0x0012e572 (97)
wbench32 ba:144 ENTER SQLError
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
UCHAR * 0x06010940 (NYI)
SDWORD * 0x0012e578
UCHAR * 0x0012e588
SWORD 513
SWORD * 0x0012e572
wbench32 ba:144 ENTER SQLErrorW
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
WCHAR * 0x0012e524 (NYI)
SDWORD * 0x0012e578
WCHAR * 0x0012e124
SWORD 1024
SWORD * 0x0012e572
wbench32 ba:144 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
WCHAR * 0x0012e524 (NYI)
SDWORD * 0x0012e578
WCHAR * 0x0012e124
SWORD 1024
SWORD * 0x0012e572
wbench32 ba:144 EXIT SQLError with return code 100
(SQL_NO_DATA_FOUND)
HENV 0x0054f300
HDBC 0x0054fe20
HSTMT 0x0220bea8
UCHAR * 0x06010940 (NYI)
SDWORD * 0x0012e578
UCHAR * 0x0012e588
SWORD 513
SWORD * 0x0012e572
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com