Not sure I understand the problem. LCDS works will work just fine as long as the table and its columns are visible to the JDBC connection.
Have you used LCDS and are you facing any specific problems? It will be great if you could provide more context.
I'm using LCDS3, and here is what I trying to do (for example):
- I have on Oracle DB table REGION, with columns: Code, State, Population.
- I want to create entity that contains same columns as table REGION (Code, State, Population) and to have addition column RegionName witch get value from PL/SQL function (loacated in package "common" on DB) "common.fgetRegionName(Code)".
Can you explain me how to create that entity.
Is that custom column backed by a PL/SQL function shown as a column in the database? If not, you can always create a derived property, This derived property has to have an expression that uses a server side function - this is just a java class. You can write your custom code to read data from the database PL/SQL function.