Subject Stored procedure - weird error...
Author tgtecchio
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.