Hello,
try
execute procedure translationstring (77 Integer ; 'Decrease' Varchar(250))
returning_values (TRANSLATEDSTRING Varchar(250))
----- Original Message -----
From: meh...@gnresound.com
To: firebird-net-provider@lists.sourceforge.net
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
| meh...@gnresound.com
------------------------------------------------------------------------------
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
