Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLS-00653: aggregate/table functions are not allowed

23055Jun 17 2005 — edited Oct 11 2005
Hi,

I defined the followin types

TYPE tw_row IS RECORD (
doc_id NUMBER,
term VARCHAR2(100),
topic VARCHAR2(100),
weight NUMBER
);

TYPE tw_tab IS TABLE OF tw_row;

I am using as follows in function definition:

FUNCTION compute_term_weight(bagwords BagWordList) RETURN tw_tab PIPELINED IS

When I compile it, I am getting

PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

I would appreciate if you have any thoughts.

Thanks.

Mustafa
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2005
Added on Jun 17 2005
2 comments
41,377 views