MySQL Forums
Forum List  »  Connector/ODBC

Re: Calling Store procedure using the CALL is not returning expected output
Posted by: Karthick perumal
Date: September 04, 2015 08:44AM

please find the ODBC trace log given below

OPCGDA 2364-1bac ENTER SQLBindParameter
HSTMT 0x008EF5A8
UWORD 1
SWORD 4 <SQL_PARAM_OUTPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
SQLULEN 0
SWORD 0
PTR 0x04EE3FD8
SQLLEN 0
SQLLEN * 0x00000000

OPCGDA 2364-1bac EXIT SQLBindParameter with return code 0 (SQL_SUCCESS)
HSTMT 0x008EF5A8
UWORD 1
SWORD 4 <SQL_PARAM_OUTPUT>
SWORD 1 <SQL_C_CHAR>
SWORD 1 <SQL_CHAR>
SQLULEN 0
SWORD 0
PTR 0x04EE3FD8
SQLLEN 0
SQLLEN * 0x00000000

OPCGDA 2364-1bac ENTER SQLGetStmtAttrW
SQLHSTMT 0x008EF5A8
SQLINTEGER 10013 <SQL_ATTR_IMP_PARAM_DESC>
SQLPOINTER 0x06F2F34C
SQLINTEGER 0
SQLINTEGER * 0x00000000

OPCGDA 2364-1bac EXIT SQLGetStmtAttrW with return code 0 (SQL_SUCCESS)
SQLHSTMT 0x008EF5A8
SQLINTEGER 10013 <SQL_ATTR_IMP_PARAM_DESC>
SQLPOINTER 0x06F2F34C ( 0x008EF834)
SQLINTEGER 0
SQLINTEGER * 0x00000000

OPCGDA 2364-1bac ENTER SQLSetDescFieldW
SQLHDESC 0x008EF834
SQLSMALLINT 1
SQLSMALLINT 1011 <SQL_DESC_NAME>
SQLPOINTER 0x04EE0F28 [ -3] "param1\ 0"
SQLINTEGER -3

OPCGDA 2364-1bac ENTER SQLSetDescField
SQLHDESC 0x008EF834
SQLSMALLINT 1
SQLSMALLINT 1011 <SQL_DESC_NAME>
SQLPOINTER 0x04EE0F28 [ -3] "p\ 0"
SQLINTEGER -3

OPCGDA 2364-1bac EXIT SQLSetDescField with return code -1 (SQL_ERROR)
SQLHDESC 0x008EF834
SQLSMALLINT 1
SQLSMALLINT 1011 <SQL_DESC_NAME>
SQLPOINTER 0x04EE0F28 [ -3] "p\ 0"
SQLINTEGER -3

DIAG [HY015] [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.19]Invalid parameter type (28)

OPCGDA 2364-1bac EXIT SQLSetDescFieldW with return code -1 (SQL_ERROR)
SQLHDESC 0x008EF834
SQLSMALLINT 1
SQLSMALLINT 1011 <SQL_DESC_NAME>
SQLPOINTER 0x04EE0F28 [ -3] "param1\ 0"
SQLINTEGER -3

DIAG [HY015] [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.19]Invalid parameter type (28)

OPCGDA 2364-1bac ENTER SQLGetDiagRecW
SQLSMALLINT 4 <SQL_HANDLE_DESC>
SQLHANDLE 0x008EF834
SQLSMALLINT 1
SQLWCHAR * 0x06F2F2D8
SQLINTEGER * 0x06F2E9E0
SQLWCHAR * 0x06F2EA00
SQLSMALLINT 513
SQLSMALLINT * 0x06F2E9D8

OPCGDA 2364-1bac EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 4 <SQL_HANDLE_DESC>
SQLHANDLE 0x008EF834
SQLSMALLINT 1
SQLWCHAR * 0x06F2F2D8 [ 5] "HY015"
SQLINTEGER * 0x06F2E9E0 (28)
SQLWCHAR * 0x06F2EA00 [ 64] "[MySQL][ODBC 5.3(a) Driver][mysqld-5.5.19]Invalid parameter type"
SQLSMALLINT 513
SQLSMALLINT * 0x06F2E9D8 (64)

Options: ReplyQuote


Subject
Written By
Posted
Re: Calling Store procedure using the CALL is not returning expected output
September 04, 2015 08:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.