Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Passing Data Sets from Oracle Stored Procedures to Progress C ode
Melanie, when a developer needed to bring data to a Visual Basic program his
books indicated that the version of VB he was using did not support
Reference Cursors or any Rowtype collections; however, it did support
receiving pl/sql tables as arrays in VB. We had to pass back an array for
each column value, but the code worked and ran well. Perhaps you will find
support for receiving a pl/sql table from a procedure as an array in your
tool.
Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Melanie Caffrey
Sent: Tuesday, February 24, 2004 6:01 PM
To: oracle-l_at_freelists.org
Subject: Passing Data Sets from Oracle Stored Procedures to Progress
Code
Hi listers,
Not really familiar with Progress code, and am trying to figure out how to pass a REF cursor, (or something similar), from an Oracle stored procedure to Progress code.
Does anyone have any ideas? (Kirti? There are a few Progress DBs over at Verizon, aren't there?)
Any pointers to any documentation, web sites, books, other list sites would be greatly appreciated.
Unfortunately, I'd never even heard of Progress before two months ago.
Best regards,
Melanie
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |