I'm studying exceptions and I would like to understand where and how are assigned error numbers, you can bind or associate when you define your named exceptions.
For example:
ex_Table_Exists Exception;
Pragma Exception_Init(ex_Table_Exists, -955);
I found this number in some sample code. I get then this message: ORA-00955: name is already used by an existing object. Or "DeadLock_Error Exception" is related to error code -60. Can please someone simply explain me how this is related and where I can see whole list with codes and their meanings. How author of this code knew that he has to use code -955, which is in this case correct?
BB