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!

If Condition in raise application error

589855Jun 8 2010 — edited Jun 8 2010

Hi,

There are 3 to 12 bind variables if any one of the bind variable values is = 'NO' then error message should pop how to add these

If
wwv_flow.g_f03(vRow) LIKE 'No' AND
wwv_flow.g_f04(vRow) LIKE 'No' AND
wwv_flow.g_f05(vRow) LIKE 'No' AND
wwv_flow.g_f06(vRow) LIKE 'No' AND
wwv_flow.g_f07(vRow) LIKE 'No' AND
wwv_flow.g_f08(vRow) LIKE 'No' AND
wwv_flow.g_f09(vRow) LIKE 'No' AND
wwv_flow.g_f10(vRow) LIKE 'No' AND
wwv_flow.g_f11(vRow) LIKE 'No' AND
wwv_flow.g_f12(vRow) LIKE 'No' THEN
rasie_application_error(12324,'Error');
end if;

Am trying something like this but if any one is NO It should throw a error message.

Please suggest me.

Thanks
Sudhir

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2010

Added on Jun 8 2010

4 comments

1,116 views