Passing a customized recordset from Oracle to VB

From: Berend <Berend.Brinkhuis_at_Eva-Tone.com>
Date: 18 Sep 2002 09:43:26 -0700
Message-ID: <3a9d48b7.0209180843.17761554_at_posting.google.com>


The recordset needs to be built in PL/SQL. The recordset is a composite of records from different tables. Also changes need to be made to values in the recordset before passing it to VB. I have used ref cursor, but noticed I cannot change the data or append to the recordset. Using PL/SQL tables looks like you have to create as many as the columns you want to pass. Can you use rowtype in the PL/SQL table and pass this to VB?

Your help is appreciated.

Thanks Received on Wed Sep 18 2002 - 18:43:26 CEST

Original text of this message