>>>
But in the documentation pages
(http://www.sapdb.org/7.4/htmhelp/a7/41ee11605911d3a98800a0c9449261/content.htm)
it says:
"If RETURNS CURSOR is specified, a database procedure is defined that
returns a results table when called."
>From that I understand that what I'm doing is possible. Perhaps you're
referring to a limitation of the JDBC driver or am I wrong in my
interpretation of the documentation?
<<<
The 'return' is not meant like a function valu, because RESULTSET
is not a SQL datatype in SAP DB. Instead, the result set is transferred
implicitly in the network protocols. Clients like JDBC can then create
a ResultSet object from the information.
To call a stored procedure from Java that returns a result set,
the following code is required.
PrepareStatement call = conn.prepareCall ("call someproc (?)");
call.setString (1, "first argument");
ResultSet cursor = call.executeQuery ();
One can also use call.execute () and then use call.getResultSet ().
Daniel Dittmar
--
Daniel Dittmar
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
