Microsoft has an excellent KB article describing how to call store procedures (SPROCs) from InfoPath using script. A must read for advanced database integration with InfoPath.
http://support.microsoft.com/kb/827007
Thanks, Shiraz