I would like to know if there is anyway I can set one of my stored procedure parameter as optional. Answer Providing a default value to the stored procedure parameter will make it optional. EDIT: CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ]