identifier must be declared
HELP!!! I have this sql statment of fields from a view and I get results, BUT when I join the view to another table in my sql statment I get the error identifier 'CNX_GET_HTS_PRODUCT_DAT' must be declared. This function is in the original view, not the added on table. CNX_GET_HTS_PRODUCT_DATA is a function (I am assuming the error message is truncating the name of the function but I could be wrong.). I have tried to recompile the function, view and even had to drop and re-create a public synonym that was invalid. All to no avail. Any thoughts on this would be greatly
0