I have a sql server and mysql background. I am a total newbie with using oracle packages so bear with me :) The DBA's here had not even heard of the collect function so not getting much help here. The package definition compiles fine (declaration). When I try to compile the body I keep getting "invalid data type" for PRED_ARRAY. Anyone have any idea what I am doing wrong?
I have a package that I have: Type PRED_REC IS RECORD ( v_pred_id PROJECT_TASK_PREDECESSORS.PRED_TASK_ID%type); Type PRED_ARRAY IS TABLE OF PRED_REC INDEX BY BINARY_INTEGER; In the package body I have: BEGIN SELECT PROJECT_ID, CAST(COLLECT(pred_task_id) as PRED_ARRAY) as preds FROM PROJECT_TASK_PREDECESSORS GROUP BY PROJECT_ID END; ~Lori ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3188 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6