Devart Forums

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

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.

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