Re: Stored procedure question ?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon May 14 2007 - 10:03:52 EDT

Next message: Marcin Skladaniec: "Re: complex query and SQLtemplate"

Previous message: Marc Gabriel-Willem: "Stored procedure question ?"
In reply to: Marc Gabriel-Willem: "Stored procedure question ?"
Next in thread: Marc Gabriel-Willem: "RE: Stored procedure question ?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This doesn't make sense to me either. So what happens of you remove
the first parameter and set "returningValue" to false?

Andrus

On May 14, 2007, at 4:58 PM, Marc Gabriel-Willem wrote:

> <procedure name="spViewCustomer" schema="dbo" returningValue="true">
> <procedure-parameter name="returnValue" type="INTEGER"
> direction="in"/>
> <procedure-parameter name="id" type="INTEGER" direction="in"/>
> <procedure-parameter name="user" type="VARCHAR" length="25"
> direction="in"/>
> </procedure>
>
> ...
>
>
>
> 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.

Next message: Marcin Skladaniec: "Re: complex query and SQLtemplate"
Previous message: Marc Gabriel-Willem: "Stored procedure question ?"
In reply to: Marc Gabriel-Willem: "Stored procedure question ?"
Next in thread: Marc Gabriel-Willem: "RE: Stored procedure question ?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon May 14 2007 - 10:04:21 EDT