Jump to content

Requesting Help in PHP ODBC Stored Procedure Calling


tamilmani

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.