Re: Sybase to Oracle conversion

Venkat,

We've just gone through that process... :)

Powerbuilder will automatically add a refcursor to the end of your stared procedure call _only_ if you call the stored proc via a datawindow. Embedded calls to stored procedures are therefore a bit messy :(

I handled temp tables by declaring a permanent table of the form: processID varchar2(12), num_col number, char_col varchar2(30); You insert and retrieve lists of identifiers using the current system process id. Delete the lot for the current process id at the end of your procedure.

HTH, David.

Venkat Kambalapally wrote:

> Hi! We have an application that has to be converted from Sybase11.5 to
> Oracle8. The application is written in Power builder 5. There are a
> number of stored procedures that return result sets. Since these have
> to be converted to ref cursors in Oracle, how do you handle them in
> powerbuilder? Also how do you handle temp tables (assuming we don't use
> Oracle8i)? Can you achieve the temp table functionality using PL/SQL
> tables?
> BTW is Oracle8i meant just for internet applications or can any two-tier
> app use it?
>
> Thanks
> Venkat
Received on Wed Jun 09 1999 - 20:38:39 CDT