Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 80864 invoked by uid 500); 2 May 2003 17:10:39 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 80777 invoked from network); 2 May 2003 17:10:37 -0000 Received: from strider.notes.duke.edu (152.16.19.13) by daedalus.apache.org with SMTP; 2 May 2003 17:10:37 -0000 Subject: Re: esql stored procedure problem To: cocoon-users@xml.apache.org X-Mailer: Lotus Notes Release 5.0.11 July 24, 2002 Message-ID: From: "Christopher Painter-Wakefield" Date: Fri, 2 May 2003 13:11:19 -0400 X-MIMETrack: Serialize by Router on strider.notes.duke.edu/DUMC_Services/mc/Duke(Release 5.0.11 |July 24, 2002) at 05/02/2003 01:11:23 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N The other thing I would recommend is to read the Sybase docs and see what it expects to happen for a stored proc call. Then compare that to your query syntax and to the generated java code. Maybe jConnect expects a slightly different set of calls, or a different query format or something. -Christopher Jeff Sexton cc: Subject: Re: esql stored procedure problem 05/02/2003 01:05 PM Please respond to cocoon-users On Fri, 2 May 2003, Geoff Howard wrote: > Wouldn't you drop "exec"? and just use proc_name in esql:call? That gives "syntax error near provDetail" The example on the apache site does not include "exec". I added it just as a guess. > >What database are you using? Are you sure "exec proc_name(...)" works > >generally? E.g., that works in SQL*Plus for Oracle, but not in other query > >tools. I'm using Sybase ASE and jConnect. I have production servlets using various types of calls, and cocoon database apps using straight queries, all working. I'd like to figure out how to call a stored procedure from xsp rather than writing a little servlet that returns XML as I have been doing so far. I'll keep trying other combinations. --------------------------------------------------------------------- To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org For additional commands, e-mail: cocoon-users-help@xml.apache.org