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!

error : not a GROUP BY expression

927867Sep 7 2012 — edited Sep 7 2012
Hi everyone,

Looks like i need some help here.. :) dont know what it means but im getting this message
00979. 00000 - "not a GROUP BY expression"
*Cause:
*Action:
Error at Line: 137 Column: 36

this is the function:

function get_path(materialID in number, materialTypeID in number, inTopFolderID in number default null, inMaterialFolderID in number default null, webMode in number default 1)
return varchar2;


and im using it on my query

,(select material_util.get_path(m.material_id, 8, 1021695, min(mf.IP_MATERIALFOLDERID), 1)
from material m, materialfolder mf
where mf.nfx_link = m.MATERIAL_ID
and m.template_id = t.template_id) as Path

looks like min(mf.IP_MATERIALFOLDERID) is having some issues here.. dont know why..

let me know guys..

thanks..

J
This post has been answered by Vivek L on Sep 7 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2012
Added on Sep 7 2012
12 comments
1,305 views