Skip to Main Content

Java Development Tools

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!

Validate Attribute value at entity level validation against Runtime DB Query

Sanjeev-OFMAug 30 2022

Hello Friends,
We are having one requirement where we need to do additional validation against a query text. I'm explaining it with the scenario.
Scenario:
We have to validate entity based view object one String attribute value (which is a combination of 8 multiple values separated via "." Value example-- "001.100.101.00012.ABC123,24343,12019,ak200") against with query text where starting 4 parameter value of String attribute need to pass in query text where clause( select count(*) from table name where param1='001' and param2='100' and param3='101' and param4='00012') and if query text count>0 than allow to save the record and if there is no record with provided combination in query text than need to show error message.

Kindly help with suggestion how we can validate it using the declarative approach.
Thanks
Sanjeev

Comments

Refer to the video below. It shows you how can you connect to a Oracle database and read data into your Excel sheet using VBA programming.
How to connect Excel to Oracle with VBA (0 Bytes)Cheers
Arsalan

User_IKOCL

Thank you.
That solved my problem.

Case solved.

1 - 2

Post Details

Added on Aug 30 2022
15 comments
514 views