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