Access Oracle CRM

I need A SQL Server 2005 stored procedure to access Oracle CRM on Demand through their web service to retrieve a list of accounts and insert the list into a table. I need a second stored procedure that given a previously retrieved account name, will retrieve all of the information for that account from Oracles CRM on demand and insert it into a table. ## Deliverables The entire product consists of the two stored procedures described. I can provide the WSDL doc and schema information for the web service. I will also supply the exact fields needed for the second stored procedure.