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?

sql oracle-database oracle9i ora-00942
Edit
Report