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.