What is stored in RB segment for creating a store procedure? Well, a bunch of new/updated records in a database dictionary.

Can you ever "rollback" the creation/modification of stored procedure? No, never. DDL are executed with implict commit, so you can't roll it back.