Can ESQL handle calls to stored procedures?
We have a java application that calls an Oracle stored procedure called
"get_titles" with one parameter (104) in the following way:
String query = "begin ? := get_titles(?); end;";
CallableStatement s = connection.prepareCall(query);
// output parameter (first ?)
s.registerOutParameter(1, OracleTypes.CURSOR);
// input parameter (second ?)
s.setInt(2, 104);
s.execute();
ResultSet r = (ResultSet)s.getObject(1);
// print the results
while (r.next()) {
System.out.println(r.getString(3));
}
This returns us a Cursor (cast as a ResultSet).
We have a database connection that works fine under Cocoon/ESQL for SELECT
commands.
Can this be written using ESQL in Cocoon, and if so, how?
Thanks for your help.
Pete
---
Cognos, London, UK
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate, or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender by
e-mail promptly that you have done so. Thank You.
---------------------------------------------------------------------
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]>
