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
[EMAIL PROTECTED]
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
