Page 1 of 1

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

Posted: Thu 05 Nov 2015 18:25
by 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;

Image

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 ?

Re: Delphi - Unidac - Android - MsSQL - Stored Procedure - tabular data stream Error

Posted: Fri 06 Nov 2015 07:35
by 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;

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

Posted: Mon 09 Nov 2015 14:56
by AlexP
hello,

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