Subject | stored procedure in view supported? |
---|---|
Author | Robert |
Post date | 2004-01-19T17:48:48Z |
I created a stored procedure with a result set (using SUSPEND command)
When I use this within a view definition like this (simplified):
CREATE VIEW MyView (ProjectId, List)
AS
SELECT ProjectId, List
FROM MyStoredProc
I get this error:
Dynamic SQL Error
SQL error code = -204
Table unknown
MYSTOREDPROC
Is using of stored procedures within a view not supported in Firebird (1.5 RC8), or do i have to report this as a bug in sourceforge.firebird-devel?
Thanks,
Robert
[Non-text portions of this message have been removed]
When I use this within a view definition like this (simplified):
CREATE VIEW MyView (ProjectId, List)
AS
SELECT ProjectId, List
FROM MyStoredProc
I get this error:
Dynamic SQL Error
SQL error code = -204
Table unknown
MYSTOREDPROC
Is using of stored procedures within a view not supported in Firebird (1.5 RC8), or do i have to report this as a bug in sourceforge.firebird-devel?
Thanks,
Robert
[Non-text portions of this message have been removed]