NEED HELP with procedure execution!!!

I need some help with the execution of a procedure I am creating.

I created a procedure that is supposed to create certain tables with the EXECUTE IMMEDIATE statement. The thing is that when I run this procedure it says that is has insufficient privileges. And I'm not running it with a different user than the one who created it.

Furthermore if I execute the same create tables as I do in the procedure it works fine!!! This is driving me crazy because I have no idea as to what I should do.

Thank you.

Make sure the user who ownes the procedure has CREATE TABLE privilege granted directly, and not through a role. Roles are disabled in stored procerdures.

Are you using Oracle 8.0.x or oracle 8.1.x ?
this will not work in oracle 8.0.x

Sonali