Search code examples
oracle-databaseoracleformsoracle8i

oracle ref() ora-00904 invalid column name

apparently there are many ora-00904 errors out there, but I can't find similar case with mine.

my case is related to ref() function in oracle: https://docs.oracle.com/cloud/latest/db112/SQLRF/functions145.htm#SQLRF00694

according to the example in the link above, you can query like below without problem:

select ref(x) from some_table x

but what I get is error ora-00904 invalid column name and it highlighted the x in ref(x)

I can't remove the ref() function from my query as it is added automatically by oracle forms.

Anyone have similar experience? is there some settings to set?

BTW, I am using an ancient oracle form 6i on top of oracle 8i

Solution

  • The ref() function is used in conjunction with user defined types; hence the table alias used by the function needs to refer to a table of a user defined type.