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!

Validating page item to be less than 50 charachters

935316Jun 8 2012 — edited Jun 8 2012
Hello,
I have created validation for page item, its string and I want it to be not more than 50 letters,
I used PL/SQL expression and I used this one
V('P55_MANAGER_NAME').length > 50

I got this error

ORA-06550: line 1, column 47: PLS-00487: Invalid reference to variable 'NEW <expression>' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Can some one help me in having the right expression??
This post has been answered by VC on Jun 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2012
Added on Jun 8 2012
10 comments
105 views