OK,

In Stored Procedures you must use the Firebird PSQL and the "result"
doesen't exists on it. Can you Post the all code?

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Chris Voronin
Enviada em: quarta-feira, 21 de dezembro de 2005 16:29
Para: firebird-support@yahoogroups.com
Assunto: RE: [firebird-support] stored procedure error.


It was done in IBO Console not in a C++ Compiler of any kind. So pretty
much I just hit Create Procedure, Added input Variable a, Added output
variable b. Then in the body had that whole text which didn't work at
all.


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Wednesday, December 21, 2005 11:20
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] stored procedure error.

> begin
> b = a;
> return b;
> end

Well, one things for sure, "return" doesn't exist in Firebird PSQL.

Care to show us the complete CREATE PROCEDURE statement?

>
> thats the entire procedure.
> a is input variable.
> b is output var.
>
> I guess I just cant figure out what I am doing wrong since this is
> very basic, its almost hello world and yet it gives me an error. Is
> there some syntax i am not writing? (if it helps i wrote this in ibo
> console that came with firebird)

No IBO Console comes with Firebird.

>
> here is the error message:
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 7, char 8
> a

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links









++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w
4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Techn
ical+support+services&c=6&s=195&.sig=s2Gugju7oqbFSnQe5CXN-g> support
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Techn
ical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+
support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support
&w6=Technical+support+services&c=6&s=195&.sig=P0EO8-oNi-ENyo4f44hTrg>
technical support Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Technical+support+services&c=6&s=195&.sig=yxbBDDzaSk3A5ChUmIs
GQg> computer technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technic
al+support&w2=Computer+technical+support&w3=Compaq+computer+technical+su
pport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w
6=Technical+support+services&c=6&s=195&.sig=waTmaDVJ1O5EVV9ojJdNIA>
technical support Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Technical+support+services&c=6&s=195&.sig=BHeXNb70xUEL93wl8Ik
WbQ> packard technical support Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support+services&w1=Techn
ical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+
support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support
&w6=Technical+support+services&c=6&s=195&.sig=V7eKfOJm-lo7uSPyz1mcEA>
support services

_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* 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]