I think he did carefully read your message, which read:

> > I test it with
> >
> > execute procedure from foo('a' || 'b')
> >
> > and I get the error message "token unknown ||".
> >
> > This looks weird to me...

To which he wrote that the correct syntax is:

> EXECUTE PROCEDURE FOO (...) RETURNING_VALUES ....

See the difference ???



Best regards,
Fred Wilson
SE, Böwe Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>




-----Original Message-----
From: Peppe Polpo [mailto:octopushole@...]
Sent: Tuesday, October 07, 2003 11:22 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: weird behaviour


Thomas,

> The correct syntax is either
>
> SELECT * FROM FOO(...)
>
> or
>
> EXECUTE PROCEDURE FOO (...) RETURNING_VALUES ....

exactly what I did.

Would you mind to read carefully my message and try to answer again ?

Regards

Peppe Polpo






--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > I create procedure FOO like:
> >
> > create procedure FOO(Text varchar(100))
> > returns
> > (result varchar(100))
> > as
> > begin
> > result=text;
> > suspend;
> > end !!
> >
> > I test it with
> >
> > select * from foo('a' || 'b')
> >
> > and I get the expected value 'ab'.
> >
> > Now I redefine procedure FOO like:
> >
> > create procedure FOO(Text varchar(100))
> > returns
> > as
> > declare variable result varchar(100);
> > begin
> > result=text;
> > end !!
> >
> > I test it with
> >
> > execute procedure from foo('a' || 'b')
> >
> > and I get the error message "token unknown ||".
> >
> > This looks weird to me...
>
> It looks weird to me how you are using your stored
> procedure. The correct syntax is either
>
> SELECT * FROM FOO(...)
>
> or
>
> EXECUTE PROCEDURE FOO (...) RETURNING_VALUES ....
>
>
> HTH,
> Thomas Steinmaurer
>
> The IB LogManager Product Family
> Logging/Auditing Suite for InterBase/Firebird
> http://www.iblogmanager.com <http://www.iblogmanager.com>

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=17051153
86:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?
camp=556&lineid=3614674&prop=egroupweb&pos=HM>

<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmai
l/S=:HM/A=1524963/rand=383836393>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]