PL*SQL stored procedure, oracle objects and Java

PL*SQL stored procedure, oracle objects and Java

Post by Bjorn Abel » Tue, 16 Dec 2003 10:06:19

"Abraham Leolo" wrote...

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

If the above line wraps, this link should work:

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

PL*SQL stored procedure, oracle objects and Java

Post by Jeff Smit » Tue, 16 Dec 2003 22:05:18 #1000888

Retrieving has never been a problem, but pushing them has been due to
connection pooling problems.


PL*SQL stored procedure, oracle objects and Java

Post by Abraham Le » Wed, 17 Dec 2003 18:14:32

Thanks for the hint, but the problem isn't yet solved.

It further it led me to an article where accessing nested tables seems
to work with Oracle 9i, since you can create Java objects within the DB. :8:1320383202207153292::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:8908169959941,

Unfortunately I am using Oracle 8i and I haven't found any way to access
nested tables without creating Java objects in the DB, which is only
supported by 9i. Though I am using Java and JDBC to access the DB I
cannot create Java objects inside the DB in the first place.

Accessing PL*SQL generated objects that reside within the nested table
would be my next problem but Oracle 8i and JDBC seem to quit with the
nested tables already. I'm going to do the PL*SQL logic in Java and just
fire some SELECTs over JDBC to the DB, since I don't see any other way
around this issue.