Skip to Main Content

APEX

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!

PL/SQL returning a Boolean

cloakedMar 29 2007 — edited Mar 29 2007
I did a quick seach and didn't see an answer.

I'm very new to ApEx and PL/SQL, so forgive my newbie question.

I want to use the 'PL/SQL Function Body Returning a Boolean' selection in the Read Only Condition Type, because I have several items to check in determining if certain fields are Read Only or Editable.

Will someone be so kind as to give me a short example of code? Doesn't need to be anything fancy. Just some PL/SQL that would be appropriate. If I have a good example I think I can take it from there.

I have a PL/SQL book and it helps, but doesn't have a good example. I have the following code but it's not correct. What am I doing wrong? (I could be way off base.)

BEGIN
IF :P10_BOAT_STATUS = 'F' THEN
TRUE;
ELSE
FALSE;
END IF;
END;


Thanks in advance, Tony
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2007
Added on Mar 29 2007
2 comments
721 views