Creating a ddl trigger that creates an oracle sql procedure?

Question

Oracle

It is necessary to create a ddl trigger that, at the time of user creation, creates the after_creation_%username% procedure (%username% is the name of the new user) for the user db_creator, which gives the create session privilege to a new user
Here is the code, sorry for the picture, there is no Internet access on the machine , and only the phone is at hand:

When I try to create a user, the following messages are displayed (sorry again for the screenshots):

I would like at least some information where you can read something about this, because I can’t find anything on the Internet about this

Answer 1

I figured out who needs it:
The error occurs due to the fact that the ddl trigger executes another ddl command and because of this, oracle thinks that a recursion is being created. To avoid this, you need to use shedule, that is, "task". I won’t give the code, figure it out for yourself how to use it, it’s not difficult there)