Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-users@xml.apache.org
Date: Fri, 2 May 2003 10:39:34 -0700 (PDT)
From: Jeff Sexton <jsexton@odshp.com>
To: cocoon-users@xml.apache.org
Subject: Re: esql stored procedure problem - spoke too soon
In-Reply-To: 
 <OFD8BD8A04.232009E8-ON85256D1A.005F9097-85256D1A.005F8E9D@notes.duke.edu>
Message-ID: <Pine.LNX.4.44.0305021033560.20589-100000@pdxlx01.odshp.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


<esql:call>
  exec provDetail(
    <esql:parameter direction="in" type="Int"><xsp:expr>pkInt</xsp:expr></esql:parameter>,
    <esql:parameter direction="in" type="String"><xsp:expr>ciString</xsp:expr></esql:parameter>,
    <esql:parameter direction="in" type="String"><xsp:expr>prString</xsp:expr></esql:parameter>
  )
</esql:call>

I thought this was working because I could tell it was trying the call; I
was getting a permission error from the database server.  Fixing that, I
starting getting this error:

 SQL Exception: JZ0SB: Parameter index out of range: 0.

I can't see where this is happening.  The generated java looks ok (to me).
It sets parameter 1, 2 and 3 not zero.

Any ideas?  Is there a syntax for setting the number of parameters?
Maybe it's jConnect specific...

Thanks


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org