When using the JDBC importer with an Oracle datasource, Oracle Packages are not available to be selected. I am only allowed to select Tables, Views, and Procedures. There should be an option to select Packages, which in my case contains stored procedures.

A ticket was submitted on the TEIID side to support this functionality.