Re: Porting Sybase stored procedures to Oracle

"Lawrence V. Rohrer" <lrohrer_at_earthlink.net> wrote:
>> Sybase --> Oracle stored procedures
 

>....I have recently ported en entire warehouse management system from Sybase
>to Oracle. This a complex system that actualy directs all of the
>material movements in the warehouse. It was implemented nearly
>exclusively in stored procedures. Converting the code, with the help of
>a text editor, is easy and straight forward.
>
.....

Interesting information.
On the other hand I think you were lucky not to encounter the multi-row situation which is very common,acutally standard in the systems I was involved with.
Your solution with arrays may not apply to non-C products such as PowerBuilder and SQLWindows.
Even if it does, stored procs would have to be modified quite a bit to take into account populating of the array, looking after number of rows returned (normally handled automaticly by Syb) etc. I still think it is generally quite complicated (but possible), and that the general translator may not work for all Syb procs.

-- 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
- - - - - - - - - - - - - - - - - - - - 
Christian Simich                            
Customer Support Platform Group    
TELSTRA  
29 / 242 Exhibition St	Phone:(03) 9634-4012  Fax:(03) 9632-5842
Melbourne  3000		Email:   CSimich_at_vitgdts1.telecom.com.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
- - - - - - - - - - - - - - - - - - - -

The views expressed in this article are mine and mine alone.
They do not represent the 
views of Telstra or any other company.