Sunday, July 1, 2012

TRY to execute select query on tablAe , that contains BLOB datatype

sql>select * from blob_test; (in 10g)
error
SP2-0678: Column or attribute type can not be displayed by SQL*Plus

solve (try this)
-------
 select utl_raw.cast_to_varchar2(a)  from blob_test;
-- where 'a' is column_name and 'blob_test' is table_name

No comments:

Post a Comment

web stats