Try creating a view. In a view you can have references to stored procedures if there is something that needs to be calculated and only a function will work. You can not select from a function. You can also create a stored procedure that returns a ref cursor.