Thank you for correcting syntax. Now I get following error

 

 

Invalid token.

Dynamic SQL Error.

SQL error code = -104.

Token unknown - line 1, char 54.

returning_values.

 

 

Yogita Mehta |Software Engineer II | GN ReSound Group | 800-621-1275 ext
3339 | meh...@gnresound.com <mailto:meh...@gnresound.com>  

 

________________________________

From: Roberto Carlos [mailto:roberto.car...@unimed-online.net] 
Sent: Wednesday, July 29, 2009 3:11 PM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] error : Executing stored procedure

 

hello, try

 

execute procedure translationstring (77, 'Decrease') returning_values
(TRANSLATEDSTRING)

        ----- 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
<mailto: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

BEGIN:VCARD
VERSION:2.1
N:Mehta;Yogita
FN:Mehta, Yogita (Chicago)
ORG:GN ReSound;Research & Development
ADR;WORK:;US-Chicago
LABEL;WORK:US-Chicago
EMAIL;PREF;INTERNET:meh...@gnresound.com
REV:20081103T151043Z
END:VCARD
------------------------------------------------------------------------------
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

Reply via email to