Re: Obtaining a ref cursor from a table object

"bung ho" <bung_ho_at_hotmail.com> wrote in message news:567a1b1.0306171246.7b35cdd7_at_posting.google.com...
> "Teppicamon" <quicog_at_hotmail.com> wrote in message
news:<bcn8t4$l1l3u$1_at_ID-162849.news.dfncis.de>...
> > Hi everybody...

[...]

> having said that, you can always create your own SQL type (e.g.,
> "create or replace type my_xphrase_tab_type as table of
> varchar2(256)"). then write a wrapper stored procedure that takes the
> results from ctx_thes.bt, uses them to populate your own table type,
> and then that can be returned to a java program as a resultset (using
> the "select column_value from table(cast(... as my_xphrase_tab_type))"
> form). as usual, check out asktom for lots of code examples of this
> kind of thing (for example:
>
>

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:246014735 810
>
> ).

Completely right indeed... Checked that sample and adapted it to my needs. Up and running in less than half an hour!!! :-)

Thank you really really much!!! Received on Wed Jun 18 2003 - 09:53:09 CDT