Skip to Main Content
Forums

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!

calling function in validation

MunishApr 26 2011 — edited Sep 28 2012
Hi,
I created an item level validation. I have a database side function which checks to make sure username/password is valid.
Under validation type I choose "Function returning boolean"

Here is what it looks like
edumet_auth('munish@edumet.com','temp1');

When I hit the login button I get error message

ORA-06550: line 1, column 44: PLS-00221: 'EDUMET_AUTH' is not a procedure or is undefined ORA-06550: line 1, column 44: PL/SQL: Statement ignored ERR-1021 Unable to run "function body returning boolean" validation.


Am I choosing wrong type of type? How can I correct this issue

Thanks
Munish
This post has been answered by fac586 on Apr 26 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2012
Added on Apr 26 2011
#apex, #apex-discussions, #function, #plsql, #validation
5 comments
449 views