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!

LOV null value return

Bob T.Jan 12 2007 — edited Mar 29 2007
Working through Advanced Tutorial. Created Parameter Report, in working with LOV types, I receive a ORA-01722: invalid number message.

This occurs when I try to retrieve all departments when lov is set to null type or in this example with null name '- ALL -.

Can someone point me to the needle in the haystack?

Thanks,
Bob
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2007
Added on Jan 12 2007
22 comments
1,576 views