[Solved]Delphi - Unidac - Android - MsSQL - Stored Procedure - tabular data stream Error

[vebaglaci]

Hi,

Connecting to MsSQL via Unidac Connection + SQL Provider on android, when i run query with standard sql commands(Select,Update,Delete etc.) everything works fine,but when i try to run Stored procedure application returns a long error message and says "RPC name is invalid.....the incoming tabular data stream...". Exact Error message as below;



My code to call stored procedure as below;

Code: Select all

sorgu.Close;
sorgu.SQL.Clear;
sorgu.SQL.Add('exec MyDatabase.dbo.Android_Servis');
sorgu.Open;

What am i missing ?

[vebaglaci]

I've solved with below code;

Code: Select all

sorgu.Close;
sorgu.SQL.Clear;
sorgu.SQL.Add('execute MyDatabase.dbo.Android_Servise');
sorgu.Execute;

[AlexP]

hello,

Glad to see that you have found the solution. If you have any other questions, feel free to contact us.