That depends. Are you talking about the text of the code? If so, you can find this in the user|all|dba _source data dictionary tables. If you are talking about the compile m-code of the proc, this is transparent and you don't really need to know, if you are talking about interpreted compilation of code, these are stored on the OS in C libraries.