How do you pass a ResultSet as an input parameter to a CallableStatement?

From: Chris (Christopher.Prior_at_justice.govt.nz)
Date: 02/13/04

  • 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)