Upon successful creation of a stored procedure, SQL_SUCCESS is returned to the client application.
SPL compilation errors and warnings are reported by the database as part of the SUCCESS return code only as a direct response to the CREATE PROCEDURE or REPLACE PROCEDURE request.
The application has to fetch the compilation errors and warnings with SQLFetch, followed by SQLGetData, until SQLFetch returns SQL_NO_DATA_FOUND.
If compilation errors are found, the stored procedure is not created or replaced.