Friday, October 7, 2011

Book Code Corrections

For the VPD functions defined in Chapter 12, the return clause lengths that I defined are insufficient. The return clause for appsec.apps_for_admin is almost 400 characters, so it is fine; but I would increase the definition of rtrn_clause to VARCHAR2(600). In appsec.apps_for_user, the return clause is over 600 characters already, so I would increase the definition of rtrn_clause in that function to VARCHAR2(1000). I like to have room to breath, even if the actual lengths of these return clauses never change.

I will make this correction in the source code in the next update.

No comments:

Post a Comment