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

From: Abraham Leolo (abraham.leolo_at_nospam.org)
Date: 12/16/03 

Date: Tue, 16 Dec 2003 10:14:32 +0100

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.

http://asktom.oracle.com/pls/ask/f?p=4950: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.

cheers,
Abraham

Bjorn Abelli wrote:
>
> 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

  • Re: J2EE and various databases, including SQL Server
    ... > Java objects in the databases, and writing stored procedure in Java. ... If you're talking about Oracle TopLink, it currently supports more than just ...
    (comp.lang.java.programmer)
  • Re: Access Oracle Objects via PLSQL from JDBC
    ... In oracle demos I couldn't find a such examples.... ... This example uses a JDBC thin client to call a PLSQL stored ... test.java - this calls the plsql and displays the resultset ... // JDBC Implementation specific connect string ...
    (comp.lang.java.programmer)
  • Re: Database wars
    ... > Queries with Prevayler are more than 9000 times faster than querying ... > Oracle through JDBC. ...
    (borland.public.delphi.non-technical)
  • Re: Wrong Return Value from statement.executeUpdate(query)
    ... On 20.04.2007 17:50, Joe Weinstein wrote: ... Oracle would need a "BEGIN delete ...; delete ...; END;". ... since JDBC 1.0. ... For example accessing meta data - although there is a clear defined interface drivers still choose to interpret arguments differently. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Help with Java Applet please...
    ... running on an old Sun box with Oracle on the same box. ... I'm stuck because of this Java Applet. ... I did some reading on JDBC, ... can't tell how it was connecting because I don't see any reference to ...
    (comp.lang.java.programmer)