Re: SQLExecDirect in CALL <stored_proc>
| From: | Andreas Karajannis | Date: | Tue, 16 Jan 2001 14:21:02 +0000 |
| Subject: | Re: SQLExecDirect in CALL <stored_proc> | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5902@lists.php.net to get a copy of this message | ||
zambak wrote:
Then I found a piece of information on DB2 CLI on Stored Procedure Call Syntax Between all it says : (quote) Unlike ODBC, DB2 CLI does not support literals as procedure arguments, parameter markers must be used.(end quote) I created a little app that users CLI and it would not work untill i used SQLBindParameter() function to connect procedure arguments to a CALL statement.... Basically You do "CALL SP_INS_MALL (?,?,?,?)" and then use SQLBindParameter() to replace ? with args..... Is there a way to call sp in PHP using current ODBC functions. Right now I don't need output parameters...only input????Please see the docs for odbc_execute() http://www.php.net/manual/en/function.odbc-execute.php and odbc_prepare() http://www.php.net/manual/en/function.odbc-prepare.php on how to pass input parameters. -Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200