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

Home -> Community -> Usenet -> c.d.o.server -> Passing PL/SQL values to REF_Cusors

Passing PL/SQL values to REF_Cusors

From: <klausk_at_my-dejanews.com>
Date: Tue, 14 Jul 1998 18:09:22 GMT
Message-ID: <6og6si$buu$1@nnrp1.dejanews.com>


Hi all,

due to the implementation of Oracle RDBMS passing records/tables over JDBC Thin Driver to an Java applet, I'm looking for a nice trick, how I can pass the values of a (multicolumn) PL/SQL table to a REF Cursor (who can be accessed via JDBC).

I do not want to create physical tables at runtime,, to get the performance up.

Any ideas ?

cu

Klaus

BTW: Although the JDBC docs say, that you can't pass records from a function to JDBC , it DOES work !

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 14 1998 - 13:09:22 CDT

Original text of this message

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