In theory, you can get the whole error message through ADO objects, so if
you really must, create the necessary ADO objects in your SP, execute the
INSERT and look at the Errors collection ...
But I admit it is weird to use ADO inside an SP in order to connect to the
very database where the SP resides. I don't have any other ideas though.