How do you pass a ResultSet as an input parameter to a CallableStatement?
Next message: redv: "Re: SQLException while using next()-method in scrolling a ResultSet"
Date: 13 Feb 2004 14:58:32 -0800
Hi All,
With the latest Oracle JDBC drivers (9.2.0.3) is it possible to set an
INPUT parameter in a SP that is a ref_cursor to a ResultSet?
I tried the following but it comes back with a SQLException saying
"unsupported feature".
callableStatementCOLC.setCursor(2, rs); // where rs =
java.sql.ResultSet
I can see in the JAVADOC from Oracle that setCursor (in
OraclePreparedStatement) has been Deprecated but what's the
replacement functionality?
Many thanks in advance, your help is much appreciated!
Chris
Next message: redv: "Re: SQLException while using next()-method in scrolling a ResultSet"
Relevant Pages
- statement.executeUpdate(String sql) - not inserting results in correct order
... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... GRDPRODPWRMAX, GRDPRODPWRMIN," + ... (comp.lang.java.databases) - using ORACLE stored procedure in ASP.NET 2.0
... Anyone experienced building gridview in Oracle environment using stored ... Since the resultSet in SP is a REF CURSOR, I am not sure what Type I ... statementHandle, CommandBehavior behavior, ArrayList& ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ... (microsoft.public.dotnet.framework.aspnet) - inserting data from resultset into oracle database - but not inserting in correct order
... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... The range of data selected from the SQL database, ... (comp.lang.java.databases) - Re: order by question
... Oracle does NOT guarantee any resultset is according to any ... suspicions your 'productive environment' is not so productive, ... valuable information for me. ... (comp.databases.oracle.misc) - Re: PL*SQL stored procedure, oracle objects and Java
... > from a stored procedure, but this resultset (a nested ... but I found an article on Oracle Technology ... "plain" types, that is, to "expand the objects" to plain types already in a ... (comp.lang.java.databases) |
|