ODBC Stored Procedures

Anon

I have a small problem with ODBC and stored procedures

I have the following stored procedure

CREATE PROC x
@ID varchar (32),
@RetVal int OUTPUT
AS
...........
SELECT @RetVal = 1

How can I get hold of the @RetVal value in my php code:

$Values = array ($USERID);
is it:
$SQL = "{ ? = CALL x ( ? )}";
or
$SQL = "{ CALL x ( ?, ? OUTPUT )}";
$Q_ID = odbc_prepare($LINK_ID,$SQL);
$Q_OK = odbc_execute($Q_ID,&$Values);

I have played around with different combinations, but either get an error or no return val?

any ideas?

Anon

I'm working with mssql on WinNT and PHPLIB.

We can call stored proc who sends a set of data, but didn't succeed to get any argument back.

We had some trouble to use stored proc.
Native API (mssql.dll) doesn't seem to work with stored proc. In fact I always receive only the first record of the dataset.
With ODBC we can call stored proc but we actually have some difficulties :
- how receive arguments back.
- calling complex procedures with text fields.

To call stored proc with ODBC you can use this syntax :

$Query_ID = odbc_prepare(Link_ID,$Query_String);
Query_Ok = odbc_execute($Query_ID);

or simplier :

$Query_ID = odbc_exec($Link_ID,$Query_String);

If anybody has more information about stored proc please help.

Anon

I spoke to one of the guys who helped develop the ODBC support in PHP and he said that at the moment you can only pass parameters into a stored procedure

there are plans for recoding the ODBC support to use ODBC 3.5 and to have the OUTPUT parameters etc available to you

so I ended up having to put the login into my script

and will have to wait

Anon

Thanks for your information.

Do you have some information about native API : using mssql without ODBC : mssql.dll or mssql70.dll.

Are there plans to improve it. Is there something to be waited in PHP4 ?

Anon

Sorry I cant help you there

My data source is MS SQL7 on NT

but I use the ODBC from php4 on my apache+linux

I use the easysoft.com ODBC-ODBC bridging software to provide the link between the linux and the NT

sorry