Subject RE: [firebird-support] stored procedure error.
Author Chris Voronin
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-----
[] On Behalf Of Martijn Tonies
Sent: Wednesday, December 21, 2005 11:20
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
> 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
Upscene Productions
Database development questions? Check the forum!


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links