Referencing a stored function in own schema with schema prefix doesn't work

Hi,

In Oracle 7 we had SELECT statements like this in a schema called (e.g.) XX:

SELECT XX.MyFunction(1234) FROM Dual

This code doesn't work any longer in Oracle 8.1.7. It yields an ORA-00904 (Invalid column name), now. If I'm omitting the schema, like in

SELECT MyFunction(1234) FROM Dual

everything works like expected.

Is there a chance to retain the old behaviour, or do we have to change our code?

Thanks in advance,

Harry Received on Tue Dec 09 2003 - 10:33:35 CST