From: Roberto C. <rob...@un...> - 2009-07-29 20:11:49
|
hello, try execute procedure translationstring (77, 'Decrease') returning_values (TRANSLATEDSTRING) ----- Original Message ----- From: Me...@gn... To: fir...@li... Sent: Wednesday, July 29, 2009 4:24 PM Subject: [Firebird-net-provider] error : Executing stored procedure Hi All, I have stored procedure named TranslationString. It takes two input parameters- one is LanguageID interger and EnglishString Varchar(250). The output is one parameter TranslatedString Varchar(250)/ In the Stored procedure Editor I can execute stored procedure well and get the expected result. I am having problem executing the same strored procedure from SQL Editor. The command I use is - execute translationstring (77 Integer ; 'Decrease' Varchar(250)) returning_values (TRANSLATEDSTRING Varchar(250)) Error - Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 1, char 9. translationstring. Can anyone help me in correcting the syntax or tell me how to execute stored procedure from SQL Editor? Thanks, Yogita Mehta |Software Engineer II | GN ReSound Group | 800-621-1275 ext 3339 | me...@gn... ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |