----- Original Message -----
From: "Luca Morandini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 11:36 AM
Subject: RE: esql - oracle stored procedure returns resultset


> just for the record: I use SQLTransformer, which runs smoothly even with
multiple cursors returned by SPs.
> I used this method for a couple of projects and for some dozens SPs... not
a glitch.

thanks, tried it out . works quit well.

Christian, i'm pretty sure that the current esql is not able to run oracle
sp in that way.
It would be possible if i could write something like that:

<esql:parameter direction="out"
type="oracle.jdbc.driver.OracleTypes.CURSOR"/>

The esql:parameter is restricted to java.sql.Type

Frank




---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <[EMAIL PROTECTED]>
For additional commands, e-mail:   <[EMAIL PROTECTED]>

Reply via email to