Re: Helping developers write a pl/sql wrapper to translate a nested table to jdbc VARRAY

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: mdemenko@xxxxxxxxxx
  • Date: Fri, 19 Jan 2007 15:40:43 -0600

Perhaps. Can one cast a IN OUT pl/sql parameter?

On 1/19/07, Maxim Demenko <mdemenko@xxxxxxxxx> wrote:

Charles Schultz schrieb:
> As pl/sql is one of my weak points, I was wondering if anyone had any
> working examples of converting TABLE to VARRAY in a pl/sql wrapper? I
> am browsing the documentation:
>
http://download-east.oracle.com/docs/cd/B19306_01/java.102/b14355/apxref.htm#BABFECBJ
>
> It gives a very limited example using BOOLEAN, which is probably the
> easiest thing in the world to convert.
> Any and all help would be much appreciate.
> TIA,
>
> --
> Charles Schultz
Could you not just use cast ?

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions016.htm#SQLRF00613

Best regards

Maxim




--
Charles Schultz

Other related posts: