cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: Calling MS SQL stored procedure
Date Wed, 20 Feb 2002 19:28:26 GMT
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message