Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Helping developers write a pl/sql wrapper to translate a nested table to jdbc VARRAY

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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 19 Jan 2007 22:35:31 +0100
Message-ID: <45B139A3.8080003@gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 19 2007 - 15:35:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US