Hello Guys,
I have the following problem and I solved it in the following way, I need to see if there are a better approaches to do that. any suggestion is welcome The problem I have function have this logic FOR record1 in SELECT .... LOOP FRO record2 in SELECT ... LOOP -- Here the function business logic changes based on a lookup table; for example, the there are many logical conditions AND and OR and the decision of how to combine these logical conditions may change based on the lookup table -- i.e in some cases the logical condition might be ' if record1. attribute1 = record2. attribute1 OR ....' or it may be ' if record1. attribute1 = record2. attribute1 AND....' -- The number of attributes is very large (around 45) which means I have endless combination of these logical conditions and also the lookup tables can be changed END LOOP END LOOP So my solution was to create atrriger on the lookup table to create this function DECLARE function_body TEXT := 'CREATE OR REPLACE .... ' .. BEGIN ... FOR RECORD in the lookup table ..... function_body = function_body EXECUTE function_body .. Regards
