dbms_sql causes insufficient previleges when called from a function or proc

dbms_sql causes insufficient previleges when called from a function or proc

 

  

hi gurus,
i am trying to create a table using dbms_sql in a procedure .
when i create the proc , it is created with out any erros .
but when i execute the proc , i get in sufficient previleges error.
please help .
note that when i use truncate , instead of create , it allows me to execute the proc .

Rgds
Rahul

Oracle LazyDBA home page