FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> Sent: November 13, 2002 11:02 AM
> > 
> > I need a simple php example of calling a mssql stored procedure that
> > has an output parameter 
>
> For now store procedure handling are not supported directly.

Output parameters have worked in dblib since 12 September.  No can do in
PHP?

Thu Sep 12 19:28:07 EDT 2002    Brian Bruns <camber AT ais.org>
        * src/dblib/unittests/t0022.c: test output params
        * src/dblib/unittests/Makefile.am: add t0022

And it works for me:

$ pwd
/usr/home/jklowden/projects/freetds/build/src/dblib/unittests
$  ./t0022
Start
About to logon
About to open
Dropping proc
Msg 3701, Level 11, State 5
Server 'NTS0214', Line 1
Cannot drop the procedure 't0022', because it does not exist in the system
catalog.
creating proc
declare @b int
exec t0022 @b = @b output

ret name 1 is @b
ret type 1 is 56
ret len 1 is 4
ret data 1 is 42
Dropping proc
dblib okay on ../../../../src/dblib/unittests/t0022.c

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.