php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #13817 odbc_exec doesn't allow stored procedures to return results
Submitted: 2001-10-24 13:40 UTC Modified: 2002-04-16 13:14 UTC
Votes:4
Avg. Score:4.5 ± 0.9
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: phpbugs at redskirt dot cx Assigned:
Status: Not a bug Package: ODBC related
PHP Version: 4.0.6 OS: IIS4 on Win NT
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: phpbugs at redskirt dot cx
New email:
PHP Version: OS:

 

 [2001-10-24 13:40 UTC] phpbugs at redskirt dot cx 
This is probably the same bug that is mentioned in Bug id #5458. As a result, the same proposed fix probably applies.

I'm attempting to retrieve values from MS SQL 7 via ODBC. The format for calling stored procs via ODBC is: 

{? = CALL stored_proc_name(?, ?)}

The question marks are place holders for variable names. 

Bug 5458 suggests making a odbc_bindparameter function to allow values to be returned properly.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-04-16 12:48 UTC] emartin_lauzer at hotmail dot com 
I recommend you to read chapter 3.4.1 of http://www.sapdb.org/pdf/usmanodbc_73eng.pdf
which explains why, when using ODBC, you cannot get return code from stored procedures whatever the database you use.
 [2002-04-16 13:14 UTC] kalowsky@php.net 
Thank you for the answer emartin.  

Unfortunately, re-writing the ODBC standard is not going to be happening in the near future so this bug is marked as BOGUS.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 11:01:30 2024 UTC