Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> accessing pl/sql tables in 8.0.5 via jdbc

accessing pl/sql tables in 8.0.5 via jdbc

From: omission9 <rus20376_at_salemstate.edu>
Date: 15 Nov 2002 06:57:35 -0800
Message-ID: <defa238f.0211150657.5f4249a4@posting.google.com>


I am tring to access an indextable created by a pl/sql procedure which is in an Oracle 8.0.5 database. When using the registerIndexTableOutParameter() method the best result I can get from the db is a SQLException informing me that this is an "unsupported feature".
Exception in thread "main" java.sql.SQLException: Unsupported feature

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)

        at
oracle.jdbc.dbaccess.DBDataSet.checkPlsqlIndexTableBindTypes(DBDataSet.ja va:685)

        at
oracle.jdbc.driver.OraclePreparedStatement.checkPlsqlIndexTableBindTypes( OraclePreparedStatement.java:2700)

        at
oracle.jdbc.driver.OracleCallableStatement.registerIndexTableOutParameter (OracleCallableStatement.java:833)

        at access_indextable.qcreport_test(access_indextable.java:54)
        at access_indextable.main(access_indextable.java:23)

Is there a workaround of any sort so that I can access a pl/sql table created in Oracle 8.0.5?
Any advice would be much appreciated!! Received on Fri Nov 15 2002 - 08:57:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US