Subject | Stored procedure - weird error... |
---|---|
Author | tgtecchio |
Post date | 2007-09-18T12:11:12Z |
Hello!
I'm using D7 + FB1.5 + IBO4.8.7, and a strange situation is
happening. For example, this statement:
SELECT SP.COL1, SP.COL2 FROM MY_PROCEDURE SP
IBO raises an error: "Cannot select RDB$DB_KEY from a stored
procedure". Well, with IBExpert works fine and with IBO4.3.Aa, too.
After I removed the aliases from statement, it works.
SELECT COL1, COL2 FROM MY_PROCEDURE
or
SELECT * FROM MY_PROCEDURE
Strange, uh?
I really appreciate some help,
Thanks in advance,
Tiago.
I'm using D7 + FB1.5 + IBO4.8.7, and a strange situation is
happening. For example, this statement:
SELECT SP.COL1, SP.COL2 FROM MY_PROCEDURE SP
IBO raises an error: "Cannot select RDB$DB_KEY from a stored
procedure". Well, with IBExpert works fine and with IBO4.3.Aa, too.
After I removed the aliases from statement, it works.
SELECT COL1, COL2 FROM MY_PROCEDURE
or
SELECT * FROM MY_PROCEDURE
Strange, uh?
I really appreciate some help,
Thanks in advance,
Tiago.