Return-Path: 
 <user-return-2402-apmail-cayenne-user-archive=cayenne.apache.org@cayenne.apache.org>
Delivered-To: apmail-cayenne-user-archive@www.apache.org
Received: (qmail 80653 invoked from network); 14 May 2007 13:59:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 14 May 2007 13:59:06 -0000
Received: (qmail 35949 invoked by uid 500); 14 May 2007 13:59:11 -0000
Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org
Received: (qmail 35931 invoked by uid 500); 14 May 2007 13:59:11 -0000
Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cayenne.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cayenne.apache.org>
List-Post: <mailto:user@cayenne.apache.org>
List-Id: <user.cayenne.apache.org>
Reply-To: user@cayenne.apache.org
Delivered-To: mailing list user@cayenne.apache.org
Received: (qmail 35922 invoked by uid 99); 14 May 2007 13:59:11 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 May 2007 06:59:11 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,UNPARSEABLE_RELAY
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [81.188.2.90] (HELO mx1.side-international.com) (81.188.2.90)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 May 2007 06:59:04 -0700
Received: with esmtp (Exim 3.36 #1 (Debian))
	id 1Hnb4U-0008Bo-00
	for <user@cayenne.apache.org>; Mon, 14 May 2007 15:58:42 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C7962F.FAC6CB58"
Subject: Stored procedure question ?
Date: Mon, 14 May 2007 15:58:41 +0200
Message-ID: <CAD995CC0E76D543B3F674B630C22DE501364695@apollo.side.lu>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Stored procedure question ?
thread-index: AceWL/dv7nWG9+a5QqCibKi5wNMTDg==
From: "Marc Gabriel-Willem" <marc.gabriel-willem@side-international.com>
To: <user@cayenne.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

------_=_NextPart_001_01C7962F.FAC6CB58
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Dear all,

=20

I've a question regarding stored procedure in MS SqlServer 2005.

=20

I would like to understand why I have to specify the following cayenne
mapping in order to be able to use my procedure properly.

This is my stored procedure:

=20

CREATE PROCEDURE dbo.spViewCustomer @ID as int, @User as varchar(25)=20

WITH EXECUTE AS SELF

AS

SELECT type_id, status FROM tCustomer (nolock) WHERE ID=3D@ID
<mailto:ID=3D@ID> =20

GO

=20

In order to be able to retrieve the result of the select statement, I've
implemented the mapping like this:

=20

...

<procedure name=3D"spViewCustomer" schema=3D"dbo" =
returningValue=3D"true">
  <procedure-parameter name=3D"returnValue" type=3D"INTEGER"
direction=3D"in"/>
  <procedure-parameter name=3D"id" type=3D"INTEGER" direction=3D"in"/>
  <procedure-parameter name=3D"user" type=3D"VARCHAR" length=3D"25"
direction=3D"in"/>
</procedure>

...

=20

I've no problem with the "id" and "user" parameters. But I really do not
understand why I have to set my "returnValue" as INTEGER with the
direction "IN"... I tried with other options but without any success.=20

=20

Could you explain me why I have to do this in that way?

=20

Thank you very much for your help.

=20

Marc Gabriel

=20

=20

=20


------_=_NextPart_001_01C7962F.FAC6CB58--