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
- Follow-Ups:
- References:
Other related posts:
- » 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
- » 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
- » 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
- » 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
- » 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
- » 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
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