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

    • 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)
    • 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)
    • Re: Huge result sets problem
      ... My environment is Windows 2003 Enterprise x64 and Oracle DB 9.2.0.3. ... problem is that I use JDBC to get one resultset from one table which exceeds ...
      (comp.lang.java.databases)
    • Re: REF CURSOR returns no rows
      ... > tables, the resultset returns empty-handed. ... > Provider from Oracle? ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: calling PL/SQL from java
      ... Just read the online JDBC book from Oracle. ... Oracle JDBC drivers support execution of PL/SQL stored procedures and ... PL/SQL block syntax. ... CallableStatement cs1 = conn.prepareCall ...
      (comp.lang.java.databases)