tamilmani Posted May 24, 2011 Share Posted May 24, 2011 Hi Everyone, This is Tamilmani Mohan , i have few doubts in SQL Stored Procedure. I am able to run the SQL SP using odbc driver and also get the result set. For Example: odbc_exec($connection,"exec get_Members"); I don't know how to run the input / output parameters SP's? Example:- If i run the below code by using SQL Management Visual Studio, I am able to insert to new record and get the member id and error code values. declare @MemberId int,@Error int EXEC INSERT_MEMBER 1,'Tamilmani','Mohan','Address1', 'Address2', 'Address3','Salem','Tamilnadu','India',9993234234 , @MemberId OUTPUT , @Error OUTPUT SELECT @MemberId , @Error I don't know how to run this type code in PHP ODBC ? Kindly , please any one give me good suggestion for this problem ? Thanks Tamilmani Mohan Link to comment https://forums.phpfreaks.com/topic/237291-requesting-help-in-php-odbc-stored-procedure-calling/ Share on other sites More sharing options...
gizmola Posted May 24, 2011 Share Posted May 24, 2011 I'm assuming this is ms sql server? You need to use the mssql extension. Link to comment https://forums.phpfreaks.com/topic/237291-requesting-help-in-php-odbc-stored-procedure-calling/#findComment-1219737 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.