Re: Calling MS SQL stored procedure

[Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>]

On 20.Feb.2002 -- 10:45 AM, Miller, Grant wrote:
> Hi,
> I'm having a problem calling an ms sql server stored procedure with the sql
> transformer (using cocoon 2.0.1 and tomcat 4).
> The code is:
> 
> <sql:execute-query>
>    <sql:query isstoredprocedure="true" name="testformike">
>       begin dbo.testformike('hi');
>       end;
>    </sql:query>
> </sql:execute-query>
> 
> The error message is:
> 
> Invalid call syntax: begin dbo.testformike('hi'); end;

Never used any of the above, but you might want to consider the JDBC
escape syntax

   {?= call <procedure-name>[<arg1>,<arg2>, ...]}
   {call <procedure-name>[<arg1>,<arg2>, ...]}

Maybe that'll make your driver happier....

	Chris.

-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>