What is Procedure? Data Dict Tables (user_procedures | user_errors [Text] | user_source [Text]) How to Create it? How to Execute it? Parameter Mode IN OUT IN OUT. CALL BY VALUE (OUT | IN OUT)| CALL BY REFRRENCE (IN) CALL BY VALUE (OUT | IN OUT) => CALL BY REFRENCE (NOCOPY Hint) -- Phone Format Sp New Format | Success | No Error Failuer | Error Msg 4 Points -> parameter List Procedure Overloading. Notations (Named | Unnamed | Mixed | Error) Local Procedure PRAGMA autonomous_transaction. How to Recompile Procedure. How to DROP Procedure.