1. Can Oracle BI execute Oracle Stored procs. So instead of using a sql select statement, would it be possible to call a stored proc?

2. My select all statement / stored proc, returns a variable amount of columns depending on some external factor. Is it possible to create a report, using a template with this setup? Therefore, the first time I call the selct / stored proc, it returns 5 columns and I want these 5 columns to be displayed in my report, in a table, using a template, whereas, next time, the call might only return 4 columns and now these 4 columnc need to be displayed in a table?