Re: PL*SQL stored procedure, oracle objects and Java

From: Bjorn Abelli (DoNotSpam.bjorn_abelli_at_hotmail.com)
Date: 12/15/03 

Date: Mon, 15 Dec 2003 02:06:19 +0100

"Abraham Leolo" wrote...

> The situation is that I get a resultset (a cursor)
> from a stored procedure, but this resultset (a nested
> table) contains objects created in PL*SQL.
> My question is simple, how to access these objects
> within the resultset from Java ?

I haven't tried it myself, but I found an article on Oracle Technology
Network that seems promising.

http://otn.oracle.com/sample_code/tech/java/codesnippet/jdbc/objects/ObjectTypes.html

If the above line wraps, this link should work:

  http://tinyurl.com/z8oy

If that doesn't help you, there's always another approach that I've seen
many Oracle developers use in the past for different obstacles. Simply
create a "wrapping procedure" that returns a "modified cursor" with only
"plain" types, that is, to "expand the objects" to plain types already in a
procedure at the Oracle Server. That approach should also make your code on
the client-side more portable...

For what it's worth, I hope my first suggestion really helps, as I probably
have to look into something similar next year...

// Bjorn A

Relevant Pages