Using APEX 24.2, I need a way to build a script to allow a use to select a row from a table and build a script to allow the data in that row to be inserted into a higher environment data table.
table structure is:
ID NUMBER No 1
TITLE VARCHAR2(255 BYTE) No 2
DESCRIPTION CLOB Yes 3
TEMPLATE_BLOB BLOB Yes 4
TEMPLATE_URL VARCHAR2(255 BYTE) Yes 5
FILE_NAME VARCHAR2(255 BYTE) Yes 6
MIME_TYPE VARCHAR2(255 BYTE) Yes 7
LAST_UPDATE_DATE DATE Yes 8
TEMPLATE_DEFAULT NUMBER(3,0) Yes 0 9
REPORT_TYPES VARCHAR2(255 BYTE) Yes 10
CREATED DATE No 11
CREATED_BY VARCHAR2(255 BYTE) No 12
UPDATED DATE No 13
UPDATED_BY VARCHAR2(255 BYTE) No 14
MIGRATED VARCHAR2(1 BYTE) Yes 15
The one column causing an issue is the template_blob column, since its a BLOB column containing a word or Excel document
I have a pl/sql procedure building sql insert script, but when I try and process through the BLOB column, I am producing a string longer than 4,000 characters for the hextoraw() function call..
Thank you!
Tony Miller
White Rock, NM