Create Stored Procedure

Question

Hi,
   If we create a stored procedure where and how is it saved and how is error handling done to the procedure. If any error occours where is it thrown. Help me.

Thanx,
Yamini.