This solution describes how to create an external table from an Oracle function How to create an External Table in Oracle from a Function