Thanks. Actually we've got it to work now, all it was was that the
in-parameter tag needed the sql namespace!
-Original Message-
From: neil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 10:30 PM
To: [EMAIL PROTECTED]
Subject: RE: Calling MS SQL stored procedure
I&#x
I'm using instead of IN parameters:
{ ? = call sp(
'',
) }
The MS JDBC driver had trouble parsing a query with new lines in it,
but at least it gets by with one long line.
In reply to:
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=101429060624988&w=2
#x27;.
But it does work with no parameters.
Any ideas?
Cheers
Grant
-Original Message-
From: neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 10:29 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Calling MS SQL stored procedure
Sorry I can't reply to
ease share any improvements you may have.
Cheers,
Neil.
Subject: Calling MS SQL stored procedure
From: "Miller, Grant" <[EMAIL PROTECTED]>
Date: 2002-02-20 15:45:47
Hi,
I'm having a problem calling an ms sql server stored procedure with the sql
transf
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:
>
>
>
> begin dbo.testformike('hi');
> end;
>
>
>
> The error message is:
>
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:
begin dbo.testformike('hi');
end;
The error message is:
Invalid call syntax: begin dbo.testformike('hi'); end;
I always get this wit
