how can i use one time only procedure in pl/sql?

Answer 1

I take it you mean an anonymous block. That can really only be used once as it is not stored in the database.

Put the procedure into sql*plus and enter '/'. that will execute it. But are you sure you only want it once?