Ora-01031 (insufficient privilege)

Hi all...

I've created a stored procedure (q_rpt) that returns my records as an user-defined object type. I'm supposed to get my records through the following sql: select * from table(cast(q_rpt as g_tab));

I created a form with a role set at the start. This form is supposed to execute the sql using dbms_sql. However, I realised that after setting the role, i'm getting the insufficient privilege (ora-01031) error.

I simulate the error at sql developer and realised i can't execute the sql after i set the role. What privilege do i need in this case?