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

  • From: Maxim Demenko <mdemenko@xxxxxxxxx>
  • To: sacrophyte@xxxxxxxxx
  • Date: Fri, 19 Jan 2007 22:35:31 +0100

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2007