Updating the Application Security Package
In Chapter 6, we had two procedures (p_get_shared_passphrase and p_get_des_crypt_test_data) and one function (f_show_algorithm) that we described as being “temporary”. They were used for testing only in Chapter 6, and we will remove them from app_sec_pkg in this chapter. The remainder of the functions in app_sec_pkg will remain and have not been changed. Look at the file, Chapter7/AppSec.sql to see the full listing. We have one new procedure that we introduce in this chapter: p_log_error.
Creating an Error Logging Procedure
The p_log_error procedure takes a NUMBER and one or two VARCHAR2 (text) parameters. The err_txt field is limited to 2,000 characters, but a VARCHAR2 column may have up to 4000 characters; ...
Get Expert Oracle and Java Security: Programming Secure Oracle Database Applications with Java now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
