Skip to Main Content
Forums

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!

To use Boolean function in DECODE or CASE statement

sriram_aJun 5 2007 — edited Jun 5 2007
Hi all
I have a scenario where i need to use a boolean function inside DECODE statement. When i tried this way iam getting "ORA-06553: PLS-382: expression is of wrong type".
I doubt whether i can use boolean function inside DECODE or not?

My query will be like this:
select decode(my_fuction( ),'TRUE',1,'FALSE',0) from dual;

Any help is highly appreciated.
Thanks
Sriram
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2007
Added on Jun 5 2007
7 comments
16,525 views