Re: Strored procedures in Sybase vs Oracle

2009-11-20 Thread L G Robinson
Hi Folks, I wanted to report back on how I resolved my problem with converting Sybase stored procedures to Oracle. But first let me thank all of the folks who responded and offered suggestions. As it turns out, Oracle procedures do not return values, but Oracle FUNCTIONS do. The only catch is

Strored procedures in Sybase vs Oracle

2009-10-20 Thread L G Robinson
Hi Folks, I am in the early stages of a migration from Sybase to Oracle and I am struggling with stored procedures. One of the nice things about Sybase is the ease with which one could return data to the ARS system using stored procedures. I am finding this much more difficult in the Orac