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"

book

Article ID: 88138

calendar_today

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).
 

<Please see attached file for image>

0EMb0000001Qubi.png

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.

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
 
select ABLOB_AH_IDNR
, 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

Attachments

1558693349724000088138_sktwi1f5rjvs16m69.png get_app