Hi,

>I've finished a stored procedure and I need it to return mytable (that I

modify in the stored procedure) so I just >added a SELECT * from mytable as
the last line of the stored procedure but I'm getting an error:

>
> SQL error code = -104.
>Token unknown - line 74, char 22.
>;.

A "select" always needs an "into" clause in a Stored Procedure.

> But a table can't be an output parameter of a SP, should I execute the

SP and then show mytable doing the >SELECT outside the SP?

That's another possibility, yes.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com