ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Oracle SQL job error "Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor"
Article ID: 88138
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message :
Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
A SQL select statement to an Oracle Database is executed in a SQL-Job, similar to the example below (marked in green). The table contains a BLOB (Binary Large Object) field. This results in the above error (marked in red).
Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
A SQL select statement to an Oracle Database is executed in a SQL-Job, similar to the example below (marked in green). The table contains a BLOB (Binary Large Object) field. This results in the above error (marked in red).
<Please see attached file for image>
Cause
Cause type:
By design
Root Cause: Blob data is not supported and needs to be converted to a string within the SQL. As blob can get several GB, displaying all this data in an SQL-job could cause the system to hang.
By design
Root Cause: Blob data is not supported and needs to be converted to a string within the SQL. As blob can get several GB, displaying all this data in an SQL-job could cause the system to hang.
Environment
OS Version: N/A
Resolution
Use DBMS_lob function similar to the one shown below. In this example the column ABLOB_CONTENT has a data type of BLOB
Fix Status: No Fix
Fix Version(s):
N/A
select ABLOB_AH_IDNR
, ABLOB_KEY
, dbms_lob.substr(ABLOB_CONTENT, 2000, 1)
from ablob
, ABLOB_KEY
, dbms_lob.substr(ABLOB_CONTENT, 2000, 1)
from ablob
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Attachments
Feedback
Yes
No
Powered by
