Thanks for your prompt reply Peter. I got this solution from Oddur. I will check it out and hope it works. Thanks & Regards Farrukh Nizami
________________________________ From: Peter Mills [mailto:[EMAIL PROTECTED] Sent: Mon 7/24/2006 10:16 PM To: [email protected] Subject: Re: Problem calling stored procedure having no parameter Hi Farrukh, You can use an empty parameter map. <parameterMap id="EmptyParam"></parameterMap> <procedure id="GetAllOrders" parameterMap="EmptyParam" resultMap="myResultMap"> GetBusinessCustomFields </procedure> Cheers, Peter Farrukh Nizami wrote: > Hi, > > I have a simple stored procedure that returns all the rows > from a table. > > CREATE PROCEDURE [dbo].[GetAllOrders] > > AS > > SELECT [OrderID] > > ,[CustomerID] > > ,[EmployeeID] > > ,[OrderDate] > > ,[RequiredDate] > > ,[ShippedDate] > > ,[ShipVia] > > ,CAST([Freight] AS Real) AS Freight > > ,[ShipName] > > ,[ShipAddress] > > ,[ShipCity] > > ,[ShipRegion] > > ,[ShipPostalCode] > > ,[ShipCountry] > > FROM [Northwind].[dbo].[Orders] > > > > How to call this stored procedure? Whenever I want to call this SP, it > complains that it need parameterMap attribute in procedure tag. But I > do not need any parameter to call this SP. Please help > > > > */Thanks & Regards > /**/Farrukh Nizami/* > > *Axentis Software Private Limited > Unit # 3, Ground Floor, Inventor Block, > I T P B, **Whitefield Road, > Bangalore: 560066, I N D I A* > *P: 91-80-28416690 / 91 / 92 / 93 Ext. 2050 > F: 91-80-28412010 > M: 0-98867-32213* > *Web:* www.axentis.com > <file:///C:/Documents%20and%20Settings/fnizami/Application%20Data/Microsoft/Signatures/www.axentis.com> >
<<winmail.dat>>
