Hi all,
my customer is using SQL Developer to migrate from Sybase to Oracle. Apparently stored procedures in Sybase return "record sets" which can then be processed by the client receiving the output; after the migration done through SQL Developer, the equivalent converted Oracle stored procedures appear to be returning "cursors" instead of "record sets" and these cannot be processed by clients (unless some hard rework is performed at the client level).
a) is there a way to force SQL Developer to produce Oracle stored procedures returning record sets?
b) has a similar problem been experienced at other customers? how was it addressed?
Thanks for your help
Antonio