I don't think you can sum character values.

>Hi Everyone!!!
>Larry Miller posted a message about the change oracle made to allow the case statement
>in sql Code see Thread#661027 Message#662099.
>But I am having problems in a PL/SQL Procedure.
>I can't use a decode because i am trying to use code like:
>

>  sum( case
>         when z = 123 and y = 432
>         then 'hello World'
>  end) as SomeTotal
>

>So I guess my question is How can I get around this?
>Thanks in advance