Fetching Multiple Rows..

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Mon, 08 Jan 2001 11:30:25 +0530
Message-Id: <10734.125951@fatcity.com>

--------------2B1A51C8CBE77E2FFB719339
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Gurus,

I am working on Sybase to Oracle (8i) Migration project. In sybase, stored procedures are having direct SELECT St. returning multiple rows.
While using OMWB (Oracle Migration Workbench) it converts that into a big
package with REF Cursor and all.

What abt. using Global Temporary Tables instead of going after this REF cursor and returning the cursor to the front end.

Did anybody tried already? Any suggestions will be appreciated.

Note - We r using the front-end - JAM Tool .

Thank You.

Arul.

--------------2B1A51C8CBE77E2FFB719339
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

Hi Gurus,
I am working on Sybase to Oracle (8i) Migration project.
 In sybase, stored procedures are having direct SELECT St. returning
multiple rows.
 While using OMWB (Oracle Migration Workbench) it converts that into
a big
 package with REF Cursor and all.
What abt. using Global Temporary Tables instead of going after this
REF cursor and returning the cursor to the front end.
Did anybody tried already? Any suggestions will be appreciated.
Note - We r using the front-end - JAM Tool .
Thank You.
Arul.</html>

--------------2B1A51C8CBE77E2FFB719339-- Received on Mon Jan 08 2001 - 00:00:25 CST