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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,286 views