Re: Sybase stored procedure -> Oracle

Roland,

  It seems there may be a misunderstanding as to the differences between Oracle & Sybase procedures. What you describe below would be implemented through a Oracle View.

  Oracle Procedures are used for data manipulation and complex data analysis. It is possible using Oracle's Dynamic component of PL/SQL to produce a function that performs the same as below, but that would entail a great deal of re-work and coding.

  Before embarking too far down the line, I would recommend you contact your Oracle representative for product details.

  I am in the process of looking at porting a application the other way ie Oracle to Sybase, and at present there appears to be some major differences in terminology and product functions available. Oracle is a more ANSI rich suite or programs, so you may find a number of Oracle facilities will make your life easier. But for me it is a complete pain to port.

  Hope this helps, if you want any more details please contact.

Neil Catton
Senior Technical Manager
Hewlett Packard UK

Roland Faszauer <r.fassauer_at_netconx.de> wrote in article <32E3B1B5.4342_at_netconx.de>...
> We are using Sybase and think about porting to Oracle.
> We have a lot of stored procedures formed like
>
> create proc getAddresses
> as
> select name, email, phone from address
>
> In Sybase the procedure getAddress returns all rows of the table
> address. Our Application calls such procedures very often.
>
> Question:
>
> In the Oracle procedures i have seen until now a stored procedure
> never returned more than OUT parameters or return values (in case
> of functions).
>
> It is possible to get the same behavior like Sybase with Oracle ?
> (We don't want to rewrite the whole Application...)
>
> Thanks in advance
>
> Roland
>
> (hope thats not in the FAQ)
>
Received on Sat Jan 25 1997 - 00:00:00 CST