Can I use SQLJ to return PL/SQL arrays from stored procedures?

Although SQL VARRAYs have been supported by SQLJ and JDBC, PL/SQL index tables are not supported by SQLJ or by JDBC at this time. You would have to use a PL/SQL stored procedure wrapper to convert a PL/SQL index table to of from a VARRAY or nested table to access the argument from Java. For example, if you are trying to call procedure proc01, defined as follows: package pack01 is type rec01 is record(n1 number, d1 date); procedure proc01 (r rec01); ... end; you can create a wrapper method as follows: package pack01_wrapper is procedure proc01_wrapper (n1 number, d1 date); ... end; package body pack01_wrapper is procedure proc01_wrapper (n1 number, d1 date) is r pack01.

Rec01; begin r. N1 := n1; r. D1 := d1; pack01.

Proc01; end; ... end; With Oracle 8i, new object types and new collection types (VARRAYs and nested tables) are available in JDBC. Thus, your wrapper package could use an object type with the same attributes as the record, rather than "exploding" the record into individual ... more.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.