Subject Re: [firebird-support] stored procedure error.
Author Martijn Tonies
> 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