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!

ORA-00937: not a single-group group function

509708Apr 29 2006 — edited Apr 29 2006
Created trigger to check the sum of two values.
the sum gets inserted to attribute i declared.
this sum should then get inserted on another table
where the id = :newid
if the sum was less than or equal to 0 then error message.

Creates fine.

insert into runway values
(
'12',runway_seq.nextval,'21-aug-06','22-aug-06',
)
;

When i insert information into the the table to run this trigger, i get

ORA-00937: not a single-group group function
ORA-06512: - the line of code which i know works before the this trigger was implemented!
ORA-04088: - the trigger name

Heard about grouping but does no difference and where would i put it

Any ideas??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2006
Added on Apr 29 2006
6 comments
472 views