I am suspecting the issue is due to the mismatch in dbtype.
Please map Oracle dbType to the proper Microsoft dataType and verify the code.
thanks and regards
I changed the Stored Procedure to use a datatype of INT instead of NUMBER and it is now working, (along with a small change to my Command Text. BEGIN; and END; is needed)