Subject Re: [firebird-support] SP not returning a table
Author Martijn Tonies

>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
My thoughts:
Database development questions? Check the forum!