support for oracle cursors

costa · Post by **costa** » Thu 27 Aug 2009 20:34

Could you please tell me if the universal data access components support oracle cursors as returned values/input-output parameters and columns returned by queries (in oracle you can return a cursor as a column). How about pl/sql tables?

Is there any complete documentation that shows which database specific features are implemented in the universal data access components vs the specific library dedicated to a single database ?

Thanks

Plash · Post by **Plash** » Fri 28 Aug 2009 08:48

UniDAC supports Oracle cursors in parameters and fields. If your query has a parameter of ftCursor data type, UniDAC will automatically open this cursor.

UniDAC does not support Oracle OBJECT, TABLE, and ARRAY data types.

There is no documentation that compares UniDAC features with the features of other DACs.

tobias_cd · Post by **tobias_cd** » Mon 31 Aug 2009 11:26

TABLE works for me like this in Unidac:
SELECT mycolumn FROM TABLE(package.functionname(1))