Unfortunately, the official specifications are not freely available, ANSI makes them available for purchase. However, there are books available, such as "SQL-99 Complete, Really" by Peter Gulutzan and Trudy Pelzer, which give a comprehensive overview of the standard including stored procedures.