Subject | SP not returning a table |
---|---|
Author | Alejandro Garcia |
Post date | 2007-04-24T17:02Z |
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.
;.
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?
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]
SQL error code = -104.
Token unknown - line 74, char 22.
;.
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?
---------------------------------
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com
[Non-text portions of this message have been removed]