It works in PL/SQL version 8.1.7 and not in 8.1.5. Using dynamic sql, we can use rollup function in 8.1.5 PL Sql version
Thanks to Shestakov & stecal