Re: Q: Sybase stored procedure -> Oracle

Your ORACLE version must be at least V7.2. PL/SQL V2.2 that comes with ORACLE V7.2 allows cursor variables. You must declare and initialize a cursor variable on your client side in a PL/SQL host environment(Pro*C, OCI, etc.). Then you pass it as a bind variable to PL/SQL that opens it (server side). After that you can fetch from it on your client side.
I work in HP UX environment and have no info on ODBC drivers for ORACLE supporting cursor variables. ORACLE native driver wor Windows, Windows 95 and NT supports that feature.

Solomon.Yakobson_at_entex.com

In article <32E3B1B5.4342_at_netconx.de>,
  r.fassauer_at_netconx.de wrote:
>
> 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)

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet