We have discussed bind variables in the A working example recipe in Chapter 1,
In this recipe, it is time to dig deeper into this topic, illustrating the benefits of using bind variables and testing the result of our efforts with simple examples. We will see examples on query statements, but the same methodologies and results apply to DML statements.
Follow these steps to prepare the database:
Chapter4to test various aspects related to bind variables.
CREATE OR REPLACE PACKAGE sh.CHAPTER4 AS PROCEDURE WORKLOAD_NOBIND; PROCEDURE WORKLOAD_BIND; PROCEDURE WORKLOAD_BIND_STATIC; PROCEDURE TEST_INJECTION(NAME ...