Dynamic SQL in a Dynamic World

The Problem

u Imagine running the example several times:

f_get_Column_tx('emp','eName','empNo',7896)

f_get_Column_tx('emp','eName','empNo',4564)

f_get_Column_tx('emp','eName','empNo',4546)

uResult:

ØSGA is occupied with exactly the same statements.

select eName from emp where empNo=7896

select eName from emp where empNo=4564

select eName from emp where empNo=4546

ØCPU time is spent re-parsing exactly the same statement.

Hard-coding each and every statement is A VERY BAD THING!