ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)

Viewed 149467

When I have a sql statement like select * from table1, it works great, but as soon as I put it into a function, I get:

ORA-00942: table or view does not exist 

How to solve this?

5 Answers
Related