ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Mills <developm...@peter.mills.to>
Subject Re: Problem calling stored procedure having no parameter
Date Mon, 24 Jul 2006 16:46:17 GMT
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>
>


Mime
View raw message