Dynamic execution of procedures and functions via configuration


Best Practicies & Success Stories

Date and time

Friday, 21. October 2016., 14:00


Hall C



Often we find ourselves in a situation that, by working on a project , writing or upgrading code becomes too complicated, execution becomes slow and ultimately code becomes difficult to maintain. Adding certain functionality becomes adding additional procedures, functions or blocks in existing procedures or functions. which can be confusing.One of the ways to improve that is for different functionalities writing universal procedures or functions that will dynamically create a block of code using configuration tables.This paper describes an example of creating procedures and functions which were used as part of the module for matching address from various external systems with internal address code-book.Addresses from the external system are entered in an arbitrary manner (in a single string attached full address; separated street , city, ZIP code , etc . ) often without a unique identifier, so it was necessary to find the matching address in the code-book and assign it a unique identifier.Matching the addresses is done through various algorithms.The idea is to make a set of procedures, functions and configuration tables in the database so that adding new algorithm is actually making an entry in the configuration table.In this way is not necessary to write procedures or functions for each algorithm which also reduces the number of objects in the database.In addition to algorithms , it was necessary to make functions for evaluation and validation of the matched addresses which leads to indicator whether the addresses are automatically matched or these is need for additional decisions, or eventually be manually selected by operators.Calling and execution of these functions is also done via the configuration table and universal procedures.The final result was a module that can be used between any system that contain addresses and internal address code-book.

Lecture details

Type: Lecture
Level of difficulty: Expert
Experience Level: Experienced
Desirable listeners function: Developers , Team leader , End user

About speaker

Best Sponsor

Better Sponsor

Good Sposor

University sponsor

Media Sponsor


The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!