• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Devaka Cooray
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • Paul Clapham
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
Bartenders:

Reading nested oracle cursors getCursor(col) throws ORA-01002 "Fetch out of sequence"

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
On oracle 9i
I'm trying to read the nested cursors that are
returned by a request, (using "cursor" keyword
or PL/SQL function which returns cursors).

however, when I try to "getCursor" or "getObject"
the cursor column, I get the "ORA-01002: fetch out of sequence" SQL exception.

metaInfo show the types are good...
autocommit is false (same with true).
How can one safely read the content of NESTED cursors?
ps: my methods works perfectly with simple
cursors returned by stored functions or procedures.

--
The request looks like
like:
select
T.*, cursor(select * from U where U.owner=T.id)
from T
or through PL/SQL function returning cursor like:
select
T.*, PACKAGE1.getUByOwner from T
I create the usual Statement,
get the ResultSet,
call
resultSet.next();
and it fails on
((OracleResultSet) resultSet).getCursor(col);

the columns is
of SQL type name "REFCURSOR" according to the ResultSetMetaData,
and metaInfo.getColumnType(col) == oracle.jdbc.OracleTypes.CURSOR
 
if you think brussel sprouts are yummy, you should try any other food. And this tiny ad:
Paul Wheaton's 16th Kickstarter: Gardening playing cards for gardeners and homesteaders
https://coderanch.com/t/889615/Paul-Wheaton-Kickstarter-Gardening-playing
reply
    Bookmark Topic Watch Topic
  • New Topic