|
|
Sponsor |
stored procedures with out parameters: msg#00052db.mysql.odbc
Hello, I am using myodbc with unixODBC. I have downloaded myodbc for solaris. now, I am facing problems executing stored procedures with out parameters. I am using the example shown in stored procedure section of MySQL reference manual : CREATE PROCEDURE simpleproc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t; END; my C code to access stored procedure: strcpy(stmt, "call simpleproc(?)") ; rc = SQLPrepare(hstmt,stmt,SQL_NTS); and binding an integer parameter, id to the statment : SQLINTEGER id; rc= SQLBindParameter(hstmt, 1, SQL_PARAM_OUTPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &id, 0, NULL); rc=SQLExecute(hstmt); if ((rc != SQL_SUCCESS) && (rc != SQL_SUCCESS_WITH_INFO)) { printf("Error in call to stored procedure %d\n",rc); SQLGetDiagRec(SQL_HANDLE_STMT, hstmt,1, stat,&err,msg,100,&mlen); printf("%s (%d)\n State : %s \n",msg,err, stat); } When I compile and run this program, I get the following error. Connected ! Error in call to stored procedure -1 [MySQL][ODBC 3.51 Driver][mysqld-5.0.19-standard]OUT or INOUT argument 1 for routine test.simplepro (1414) State : HYT00 Initially I thought State: HYT00, is something related to timeout. so changed the statement attribute and changed the timeout period. but that also doesn't help I even tried the "?=call simpleproc()" but this gives syntax error. I spoke to unixODBC people also, they are saying, the problem is in myodbc. so please help me. thanks and regards sharari
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | RE: powerbuilder application running in Linux connecting to mysql, Martin J. Evans |
|---|---|
| Next by Date: | RE: Status update? -- Guidelines for MyODBC 5 testers, Nick Cranham |
| Previous by Thread: | powerbuilder application running in Linux connecting to mysql, Gestalt Consulting Inc. |
| Next by Thread: | RE: stored procedures with out parameters, Nagesh Sharvari-A21337 |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website.
|