Attached File API
I need to know if the API I'm using is it safe to Run it to PROD this API contain INSERT INTO FND_LOBS,
/* Formatted on 03-Feb-19 12:04:43 PM (QP5 v5.185.11230.41888) */
DECLARE
l_rowid ROWID;
l_attached_document_id NUMBER;
l_document_id NUMBER;
l_seq_num NUMBER;
l_category_name VARCHAR2 (100) := 'Miscellaneous';
l_category_id NUMBER;
l_security_id NUMBER;
l_filename VARCHAR2 (240);
l_pk1_value NUMBER;
l_entity_name VARCHAR2 (100) := 'PER_PEOPLE_F';
l_file BFILE;
l_file_exists NUMBER := 0;
l_file_size NUMBER;
l_media_id NUMBER;
l_dstn_file BLOB;
mess_error VARCHAR2 (4000);
CURSOR main_cur
IS