I have worked on a SQL Server to Oracle conversion. I
used the Workbench product to do some of the
conversion of our stored procedures. The problem is
Oracle procedures can not return result sets unless
you declare a ref cursor. If you have any specific
questions you can email me directly. I may be able to
give you some direction. If so please email me at
jellis24_at_hotmail.com
James
--- Arul kumar <rakumar_at_mahindrabt.com> wrote:
> 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.
>
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
Received on Mon Jan 08 2001 - 08:02:53 CST
