Share this page

# Example: lrd_assign_bind_ext

In the following example, lrd_assign_bind_ext assigns the contents of the array emp to the host variable newemp_D4 , and then binds the host variable to the placeholder. The array emp, contains the required values, and it was defined as int emp[15] at the beginning of the script.

The actual recorded code was:

    lrd_stmt(Csr1, "insert into employee values ('Joe Taylor',:newemp," "'1-JAN-97','R&D',22)", -1, 0 /*Non deferred*/, 2 /*Ora V7*/, 0);

    lrd_assign_bind(Csr1, "newemp", "70", &newemp_D4, 0, 0, 0);

    lrd_exec(Csr1, 0, 0, 0, 0, 0);

    If the names contain null characters and are variable length, you modify the existing code in the following way:

    lrd_assign_bind_ext(Csr1, "newemp", emp[1], 9, &newemp_D4, 0, 0, 0);

    lrd_exec(Csr1, 0, 0, 0, 0, 0);

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: