Re: "decode" the boolean value retruned from a stored function

Vahidt A. Tadjkarimi wrote:  

>
> sql> select decode(PLUS_MINUS_BO(2,3), TRUE, '+', '-') from dual;
>
> I get:
>
> ERROR at line 1:
> ORA-00904: invalide column name
>

 Change your statement to following:

select decode(PLUS_MINUS_BO(2,3), 'TRUE', '+', '-') from dual;

-- 
+---------------------------------------------------------------------+
| Xu, Guo Miao (Mr.)                       xgmiao_at_hk.super.net        |
| (Hui, Kwok Miu in Cantonese)             huikomix_at_dt.com.hk         |
| Unix & Oracle System Administrator       Tel: (00852) 2589 3369     |
| Cho Yang (Hong Kong) Co., Ltd.           Fax: (00852) 2559 3049     |
+---------------------------------------------------------------------+