Subject | [ib-support] |
---|---|
Author | Rotandiko Sastroprawiro |
Post date | 2002-07-30T06:56:58Z |
Dear All,
I want make a VIEW where the select command like this :
CREATE VIEW (LANGUAGES_ENGLISH_NAME)
AS
SELECT LANGUAGES_ENGLISH_NAME FROM GETTING_PUBLISH(4,'MANAGER');
which GETTING_PUBLISH is a stored procedure. When i run this at IB Console ,
always
error :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 43
(
why ? Is firebird does not allow reslt from sotred procedure to be a VIEW ??
I want make a VIEW where the select command like this :
CREATE VIEW (LANGUAGES_ENGLISH_NAME)
AS
SELECT LANGUAGES_ENGLISH_NAME FROM GETTING_PUBLISH(4,'MANAGER');
which GETTING_PUBLISH is a stored procedure. When i run this at IB Console ,
always
error :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 43
(
why ? Is firebird does not allow reslt from sotred procedure to be a VIEW ??