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>
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